February 26, 2019 at 12:03 am
Comments posted to this topic are about the item Monitoring the Number of Connections
February 26, 2021 at 9:25 am
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
February 26, 2021 at 2:08 pm
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy