sleeping connection limit

Question

sleeping connection limit

PHXHoward

SSCrazy Eights

Points: 8389
More actions
September 25, 2013 at 4:20 pm

#395556

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Kenny Jozi SSCrazy Points: 2028 More actions · Answer 1

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

PHXHoward SSCrazy Eights Points: 8389 More actions · Answer 2

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.

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 3

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.

PHXHoward SSCrazy Eights Points: 8389 More actions · Answer 4

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.