How to check the number of connections

Question

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

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

Adam Angelini SSCrazy Eights Points: 8548 More actions · Answer 1

SSCrazy Eights

Points: 8548

October 1, 2007 at 1:50 pm

use sp_who2

noeld SSC Guru Points: 96590 More actions · Answer 2

select * from sys.dm_exec_sessions -- 2005 style 😉

* Noel

Steve Jones - SSC Editor SSC Guru Points: 738683 More actions · Answer 3

Not really supported, but counting by database.

select count(s.spid)

, d.name d

from sys.sysprocesses s

inner join sys.databases d

on s.dbid = d.database_id

group by d.name