Contents tagged with monitoring
-
SQL Server Database Monitoring
--Find active connections to the instance
USE master;
GO
EXEC sp_who2 'active';
GO
--Find number of active connections to database
USE master;
GO
SELECT DB_NAME(dbid) AS DBName,
spid,
COUNT( … more