Monitoring the Number of Connections

  • Comments posted to this topic are about the item Monitoring the Number of Connections

  • Hi Andy, I have a server where I have 2 instances, default and a named 1. When I execute the styatement

    SELECT *

    FROM sys.dm_os_performance_counters

    WHERE counter_name = 'User Connections';

    In the default, I get 11, in the named instance I get 7 and in perfmon at the same time I have 9 so 3 different figures, how this can be interpreted? Thanks

  • Great article. I like "User Connections" counter for the fact that it's a forward looking metric to monitor where you can be pro-active as opposed to being re-active to issues.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply