Post reply

Sleeping processes

  • February 3, 2014 at 2:25 pm

    #396213

    I have a sql cluster and it has about 500 sleeping spid, what should I do? Thank in advance.

  • February 3, 2014 at 2:48 pm

    #1685653

    Nothing, not dangerous. Let them sleep :), they do not overload your system.

    Regards,

    Igor

    Igor Micev,My blog: www.igormicev.com

  • February 3, 2014 at 4:03 pm

    #1685675

    Looks like connection pooling to me. Read the following article: http://msdn.microsoft.com/en-us/library/8xx3tyca.aspx


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • February 3, 2014 at 8:54 pm

    #1685724

    In application are they closing the connections properly?.

    As the above user indicates it wont harm your server when a new requests comes it will use the sleeping connection.

    Regards
    Durai Nagarajan

  • February 4, 2014 at 10:16 am

    #1685930

    I don't know if the application close connection properly. I should talk to the application owner, or there is way to find out from sql server side?

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

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