NTSEQ:- A IT Infrastructure and Cyber Security Blogs

How to find number of connection in SQL Server based on each databases

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

SQL Server -DBA

Post navigation

Previous Post:How to kill all connection of a databases in sql server ?

Next Post:How to find Total connection in sql server ?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Search

C Programming
C++
Cyber Security
Interview FAQ
Java
Linux
MySQL
Netseq.com
Oracle
PHP
Python
SQL
SQL Server -DBA

Active Directory Security: Strategies to Safeguard Your Organization
PowerShell scripts for Active Directory (AD)
Top 50 Essential Active Directory PowerShell Commands and Administrative Tools
Critical Windows Event ID’s to SOC Team Must Monitor
Top Cybersecurity Threats in 2025 and How to Protect Yourself

WordPress Theme: Wellington by ThemeZee.