mm

I have 18 years of IT experience with 16 Years on SQL Server as DBA. Expert in setting up Disaster Recovery across data centers. Expert in planning and providing High Availability solutions. Expert in Upgrades, migrations. Maintains SQL Server environment with zero critical and zero high severity remediation by Microsoft SQLRaaS assessment.

Share this post

Find Number Of Sessions On Each Database

in SQL Server - Production Support, SQL Server DBA
Share via:
Post Views: 0

Find Number Of Sessions On Each DatabaseFind Number Of Sessions On Each Database

select COUNT(1)as Number_Of_Connections, DB_NAME(dbid) as Database_Name from sysprocesses group by dbid  order by 1 desc

 

Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts
Instagram : https://www.instagram.com/knowledgesharingplatform

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (10 votes, average: 5.00 out of 5)
Loading...

You might also like...

2 thoughts on “Find Number Of Sessions On Each Database”

Add Comment