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

al4629740Asked:
Who is Participating?
 
Vijay Pratap SinghConnect With a Mentor Commented:
These are not a concern to worry as its just socket connection for SA as it provide different connections per database and it will not create any issue.
0
 
Matt BowlerConnect With a Mentor DB team leadCommented:
You should add:

and spid > 50

to you where clause to filter out the sql internal and background processes.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.