Hi Team,
I am getting the below error for MSSQL Longest Transaction Running Time monitor.
ERROR: [MSSQLQuery::run_on_connection] Query (longesttrans) Failed!! No Results! returnCode [] query [SELECT cntr_value as value, DATEDIFF(SECOND, '1970-01-01', GETUTCDATE()) as utctimestamp FROM sys.dm_pdw_nodes_os_performance_counters WHERE counter_name='Longest Transaction Running Time' AND instance_name='':] (2175)
Below are the command I am using
check command: check_xi_mssql_server2
command view: $USER1$/check_mssql_server.php -H $HOSTADDRESS$ $ARG1$
$ARG1$: --checktype 'server' -U '<username>' -P '<password>' --perftype pdw -p 1433 --mode longesttrans --warning 1200000 --critical 1800000
Can you please check and let me know how this can be resolved
Regards,
Preethu
ERROR: [MSSQLQuery::run_on_connection] Query (longesttrans)
Re: ERROR: [MSSQLQuery::run_on_connection] Query (longesttra
Hi
Please change:
--perftype pdw
to:
--perftype default
Let me know if that works for you.
Thanks
Please change:
--perftype pdw
to:
--perftype default
Let me know if that works for you.
Thanks
Re: ERROR: [MSSQLQuery::run_on_connection] Query (longesttra
Hi,
It is working after making changes. Thanks for the help.
Regards,
Preethu
It is working after making changes. Thanks for the help.
Regards,
Preethu