Monitoraggio delle connessioni attive

[FrancyDotNet]

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;