Contents tagged with DBA
-
How to Linux for SQL Server DBAs
https://www.red-gate.com/simple-talk/sql/sql-linux/how-to-linux-for-sql-server-dbas-part-1/
-
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