Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

User Connection Count Doesn't Match Expand / Collapse
Author
Message
Posted Wednesday, March 13, 2013 10:08 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 1:32 PM
Points: 41, Visits: 119
I was greeted this morning with alerts that the user connection count on one of our testing DB server was up to 380. I verified this amount in perfmon. However, when I check activity monitor, sys.dm_exec_sessions, and master.dbo.sysprocesses to find out what's going on I am only able to locate 21 system and 16 user processes. Any ideas on how to trace down where the 380 comes from?
Post #1430503
Posted Wednesday, March 13, 2013 10:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:14 PM
Points: 13,139, Visits: 11,980
Mia G (3/13/2013)
I was greeted this morning with alerts that the user connection count on one of our testing DB server was up to 380. I verified this amount in perfmon. However, when I check activity monitor, sys.dm_exec_sessions, and master.dbo.sysprocesses to find out what's going on I am only able to locate 21 system and 16 user processes. Any ideas on how to trace down where the 380 comes from?


That sounds suspiciously like there is some new code running that is not disposing of the connection objects correctly. I have seen this happen when .NET devs do not dispose of their connections. It filled up the pool to 999 connections and no new ones could be made until the pool killed the idle connections when they timed out.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1430512
Posted Wednesday, March 13, 2013 10:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 1:32 PM
Points: 41, Visits: 119
Hmm. There is no active testing or development going on with the DBs on this server. Any suggestions on where I can narrow down potential sources? Don't see anything in the event logs.
Post #1430531
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse