How to determine total number of open/active connections in sql server 2008 R2
How to determine total number of open/active connections in sql server 2008 R2
sql code :
SELECT
DB_NAME(dbid) as DataBase_Names, COUNT(dbid) as total_connections,
loginame as UserName
FROM
sys.sysprocesses
WHERE
dbid > 0
GROUP BY
dbid, loginame
sql code :
SELECT
DB_NAME(dbid) as DataBase_Names, COUNT(dbid) as total_connections,
loginame as UserName
FROM
sys.sysprocesses
WHERE
dbid > 0
GROUP BY
dbid, loginame
How to determine total number of open/active connections in sql server 2008 R2
Reviewed by (C#) Csharp examples
on
11:25 PM
Rating:
No comments: