MSSQL Connections passwordstate

[rrnetz]

Hi,

 

at my monitoring of passwordstate (V8.9 (Build 8951) i catch today current situation. The MSSQL connection cames from normal workload at around 8 MSSQL connections to 93 at peak.

After short restart the MSSQL server the connections goes to 25. 

 

SELECT 
    DB_NAME(dbid) as DBName, 
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
FROM
    sys.sysprocesses
WHERE 
    dbid > 0
GROUP BY 
    dbid, loginame
;

 

 

So from my side its feel not so pretty. Have anyone some idea or hint?

 

THX Stefan

Edited July 28, 2020 by rrnetz
added passwordstate version