al4629740
asked on
Why do I have so many connections
I ran this command to find the number of connections
Here are my results. Why does the master have 18 open connections. How does that happen. I only use one database that is callled CAPRegisters
SELECT db_name(dbid) as DatabaseName, count(dbid) as NoOfConnections,
loginame as LoginName
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid, loginame
Here are my results. Why does the master have 18 open connections. How does that happen. I only use one database that is callled CAPRegisters
DatabaseName NoOfConnections LoginName
msdb 2 NT AUTHORITY\NETWORK SERVICE
ReportServer 1 NT AUTHORITY\NETWORK SERVICE
master 18 sa
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.