SQL Server Performance

Why so many process is sleeping

Discussion in 'General DBA Questions' started by Linus Yeung, Jan 11, 2007.

  1. Linus Yeung New Member

    I want to know why there are so many sleeping processes found in Enterprise Manager under below location?

    Management
    -> Current Activity
    ---> Process Info

    there are more than 50 sleeping process, do they affect SQL Server Performance ?

    Million Thanks
  2. MohammedU New Member

    They will effect the performance but you need to check from where they are coming...
    If your application is not closing connection after the request they will be there in SQL and SQL will not cleanup.
    Every connection takes some memory ...I don't remember the value at this time...


    Mohammed U.
  3. Linus Yeung New Member

    Can i setup some jobs to kill them automatically?
  4. Raulie New Member

    A SPID set to Sleeping status basically indicates that the process has completed executing however it is waiting for further instructions from the application. They can become a serious problem is they are blocking out other SPIDs you can delete them one by one or create a script to delete them all for you.

    Raulie



Share This Page