|
List connections on sql server 2008 |
|
|
|
|
Sunday, 13 December 2009 |
How do I list all of the connections or view the total connections in use on SQL Server 2008
The answer is in this little script
SELECT DB_NAME(dbid) as 'Database Name',
COUNT(dbid) as 'Total Connections'
FROM sys.sysprocesses WITH (nolock)
WHERE dbid > 0
GROUP BY dbid
Thanks for http://www.sqldba.org/.../18-view-database-connections-in-sql-server.aspx
Its a life saver
|
VB.NET/ASP.NET