| Check Number of Connections Open in SqlServer |
|
How to find number of connections open in the SQL server?
|
|
RajKumar |
Answered# (13)
|
|
Reply For This Question
|
|
|
|
Answer(s) Posted
|
|
|
Check Number of Connections Open in SqlServer
|
|
SELECT
DB_NAME(dbid) as DbName,
COUNT(dbid) as NumberOfConnections,
loginame as LoginName
FROM
sys.sysprocesses
WHERE
dbid > 0
GROUP BY
dbid, loginame
|
|
Raj Kumar
| Answered# (13)
|
|
|
|
Post Your Answer
|
Please login to post your answer.
|
|
|
|