Get alerted on high number of user connections in SQL Monitor

How can I get an alert in SQL Monitor if there is a certain % above baseline (or even just > 1000 for example) of new user connections? I need this to help reduce high CPU in SQL when there is an app with a connection leak issue.


  • Hi administrator,

    Unfortunately there isn't a metric currently in SQL monitor for such a thing. You could create a custom metric using something like the below to get the desired effect.

    SELECT dopc.cntr_value FROM sys.dm_os_performance_counters AS dopc
    WHERE dopc.counter_name = 'User Connections'
Sign In or Register to comment.