Link to home
Start Free TrialLog in
Avatar of al4629740
al4629740Flag for United States of America

asked on

Why do I have so many connections

I ran this command to find the number of connections

SELECT db_name(dbid) as DatabaseName, count(dbid) as NoOfConnections,
loginame as LoginName
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid, loginame

Open in new window



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                                                                                                                              

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Vijay Pratap Singh
Vijay Pratap Singh
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Matt Bowler
Matt Bowler
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial