ERROR: [MSSQLQuery::run_on_connection] Query (longesttrans)

[preethu.d]

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

[gsmith]

Hi

Please change:
--perftype pdw
to:
--perftype default


Let me know if that works for you.

Thanks

[preethu.d]

Hi,

It is working after making changes. Thanks for the help.

Regards,
Preethu