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
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 Reviewed by (C#) Csharp examples on 11:25 PM Rating: 5

No comments:

Facebook

Powered by Blogger.