Getting the SQL Connections

Question

Getting the SQL Connections

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
March 11, 2021 at 12:00 am

#3850826

Comments posted to this topic are about the item Getting the SQL Connections

Viewing 5 posts - 1 through 4 (of 4 total)

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

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 1

I looked at the link for dm_os_performance_counters but can't figure out where it says to use counter_name = 'User Connections'. What am I missing?

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

Not sure what your question is. The ref is a general link for the DMV. The link from there to SQL Server objects describes each counter. This would be the query

SELECT * FROM sys.dm_os_performance_counters 
WHERE counter_name = 'User connections'

WILLIAM MITCHELL SSChampion Points: 13766 More actions · Answer 3

Thanks Steve I did figure it out. IMHO the explanation could have been a bit more detailed. I can follow dm_os_performance_counters to get to the SQL Server objects, but then you have to "know" that you have to select General Statistics, and then the last item is User Connections.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 4

Actually, you can just use the counter. Don't need the object, but certainly the explanation can usually be improved.

Love to see you or others submit something if you think of any interesting questions. Use the "Write for Us" link in the upper right.