Get alerted on high number of user connections in SQL Monitor

administratoradministrator Posts: 11 Bronze 1
in SQL Monitor 6
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.
Thanks!
Tagged:
· Share on Twitter

Answers

  • ATurnerATurner Posts: 204 Silver 2
    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'
    · Share on Twitter
Sign In or Register to comment.