Monitoraggio delle connessioni attive
Inviato: 22/06/2024, 5:12
Codice: Seleziona tutto
SELECT
DB_NAME(dbid) AS DatabaseName,
COUNT(dbid) AS NumberOfConnections,
loginame AS LoginName
FROM
sys.sysprocesses
WHERE
dbid > 0
GROUP BY
dbid, loginame;