Solved

Why do I have so many connections

Posted on 2013-06-23
2
238 Views
Last Modified: 2013-06-24
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

0
Comment
Question by:al4629740
2 Comments
 
LVL 6

Accepted Solution

by:
Vijay Pratap Singh earned 350 total points
ID: 39270217
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
 
LVL 9

Assisted Solution

by:MattSQL
MattSQL earned 150 total points
ID: 39270382
You should add:

and spid > 50

to you where clause to filter out the sql internal and background processes.
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now