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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:25 PM
Points: 295, Visits: 865
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 Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 4:47 AM
Points: 260, Visits: 686
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 2005/2008 DBA - MCTS/MCITP
Post #1498740
Posted Thursday, September 26, 2013 11:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:25 PM
Points: 295, Visits: 865
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: Yesterday @ 8:43 AM
Points: 1,201, Visits: 2,661
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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:25 PM
Points: 295, Visits: 865
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