Category Archives: SQL Server

Last Query for All Open Connections (source): SELECT    * FROM    sys.dm_exec_requests er     CROSS APPLY    sys.dm_exec_sql_text(er.sql_handle) AS t Number of Open Connections (source): SELECT      DB_NAME(dbid) as DBName,      COUNT(dbid) as NumberOfConnections,     … Continue reading →