Post reply

Sleeping process...

  • May 28, 2015 at 6:18 am

    #1801231

    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

  • June 1, 2015 at 8:57 am

    #1802018

    Thank you.

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

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