UIM sqlserver probe is not generating an alarm when condition matches

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We have setup this profile and you can see that it does return data, why does it not generate an alarm?

Environment

Any version of sqlserver

Cause

For the output of Counter column, there were so many spaces got added at the end, and in the probe configuration, customer entered Key Column Value without spaces. So the strings were not matching and that is why alarm didn't get generate.

 

Counter column output with spaces added at the end. Highlighted in red are white spaces.

 

 

Resolution

Modify the query as below, so that all the white spaces will be trimmed and then the strings will be matched with Key Column Value.

 

select

            cntr_value AS Value, 

            RTRIM(counter_name) AS Channel

FROM sys.dm_os_performance_counters

WHERE counter_name IN (

            'User Connections'

           , 'processes blocked'

           )

ORDER BY counter_name