Run this query and get total no of connections in sql server
SELECT DB_NAME(dbid) AS databasename,
COUNT(dbid) AS Connections,
loginame
FROM sys.sysprocesses
GROUP BY dbid, loginame
ORDER BY DB_NAME(dbid)
SELECT DB_NAME(dbid) AS databasename,
COUNT(dbid) AS Connections,
loginame
FROM sys.sysprocesses
GROUP BY dbid, loginame
ORDER BY DB_NAME(dbid)
0 comments:
Post a Comment