How find out number of active SQL Server connections?

 SELECT

    DB_NAME(dbid) as DBName,

    COUNT(dbid) as NumberOfConnections,

    loginame as LoginName FROM sys.sysprocesses

WHERE dbid > 0 GROUP BY dbid, loginame;

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email