Friday, November 20, 2009

How To Find The Number Of Live Connection In Database

SELECT DB_NAME(dbid) AS db, COUNT(dbid) AS connection FROM SYS.SYSPROCESSES WHERE dbid > 0
GROUP BY dbid

No comments: