Sleeping process...

  • Gail Shaw

    SSC Guru

    Points: 1004474

    reddysiri517 (5/28/2015)

    Good day, please confirm sleeping sessions or stale session in sql server will use CPU.

    If we kill sleeping sessions,CPU will come down.

    No. Sleeping sessions are doing nothing. Since they're doing nothing, they can't be using CPU.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • reddysiri517

    SSC Journeyman

    Points: 92

    Thank you.

Viewing 2 posts - 16 through 17 (of 17 total)

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