March 13, 2013 at 10:08 am
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?
March 13, 2013 at 10:29 am
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 13, 2013 at 10:53 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply