Find Number Of Sessions On Each Database

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