dmv, active, tsql - SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)

Browse by Tags

SQL Server: Quick way to find Active & idle connections on a SQL instance Published 2 May 8 4:32 AM | SSQA.net: Using SQL Server 2005 you can take help of DMV - sys.dm_exec_connections that will give server-level information about the connections. In the olden days usage of sysprocesses system table used to be heavy and same approach can be achieved by using system...

Filed under: sql server, dmv, transaction, connections, tsql, sysprocesses, active