Solved

Why do I have so many connections

Posted on 2013-06-23
2
242 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
migration MS SQL database to Oracle 30 60
SQL: launch actions one before the other 10 22
2016 SQL Licensing 7 41
SQL Error - Query 6 25
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

776 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