Jump to content

MSSQL Connections passwordstate


rrnetz

Recommended Posts

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. 

 

547447847_Bildschirmfoto2020-07-28um10_13_07.png.fb058d7cc9009c3d1b302d5b2b78f504.png

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

1926881479_Bildschirmfoto2020-07-28um10_19_50.png.1e8baf923633ef3383d84ebde80772c6.png

 

548962482_Bildschirmfoto2020-07-28um10_21_50.thumb.png.f9d184137ba0aea08b9d226e2cb4751e.png

 

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

 

THX Stefan

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...