Jump to content

MSSQL Connections passwordstate


rrnetz
 Share

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

Edited by rrnetz
added passwordstate version
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...