Post reply

Monitoring the Number of Connections

  • February 26, 2019 at 12:03 am

    #381560

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

    Andy
    Connect with me on LinkedIn

  • February 26, 2021 at 9:25 am

    #3850472

    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

    #3850598

    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