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

sleeping connection limit Expand / Collapse
Author
Message
Posted Wednesday, September 25, 2013 4:20 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 3:10 PM
Points: 306, Visits: 967
One of my SQL Servers has 15,835 connected session with only 4 active. One application account has 15500+ sleeping connections with last batch date on most of them going back almost a month.

My other SQL Servers will see between a few and a few hundred sessions. Is 15,000 excessive? Could it be due to some app pool setting? Does SQL Server have an option to release connections that are idle for a period of time?

Thanks!

Howard

Post #1498618
Posted Thursday, September 26, 2013 3:36 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 5:14 AM
Points: 417, Visits: 803
SQL Server will not kill or drop any connection/process unless the service is initiated for a restart or referred from the client process

A sleeping session is waiting for its next command from the application, and is most like a pooled connection; in either case it isn't using any resources.

Have you checked whether your system is having some sort of hardware bottleneck or not ?


SQL 2000/2005/2008/2012 DBA - MCTS/MCITP
Post #1498740
Posted Thursday, September 26, 2013 11:21 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 3:10 PM
Points: 306, Visits: 967
kenneth.mofokeng (9/26/2013)
SQL Server will not kill or drop any connection/process unless the service is initiated for a restart or referred from the client process

A sleeping session is waiting for its next command from the application, and is most like a pooled connection; in either case it isn't using any resources.

Have you checked whether your system is having some sort of hardware bottleneck or not ?


I've asked the application team to look into it. A day later, this server is up to 16,900 sleeping connections from the same application account.
Post #1498973
Posted Thursday, September 26, 2013 12:43 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:32 AM
Points: 1,324, Visits: 2,941
Most applications have a configuration for their app pool connections...

like

Minimum number of connections, Max number of connections and sometimes a timeout if not used number.



Post #1499015
Posted Thursday, September 26, 2013 12:53 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 3:10 PM
Points: 306, Visits: 967
Markus (9/26/2013)
Most applications have a configuration for their app pool connections...

like

Minimum number of connections, Max number of connections and sometimes a timeout if not used number.



I've checked with the middleware team. They do have a limited connection pool. These connections are coming directory from the app server so vendor support may be necessary.
Post #1499019
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse