Post reply

sleeping SPIDs consume CPU and memory ?

  • September 25, 2017 at 9:00 am

    #325550

    Good Morning Experts,
    Do the sleeping SPIDs consume CPU and memory while they are in sleeping state?

  • September 26, 2017 at 5:41 am

    #1960926

    coolchaitu - Monday, September 25, 2017 9:00 AM

    Good Morning Experts,
    Do the sleeping SPIDs consume CPU and memory while they are in sleeping state?

    As far as I know , its the cumulative value of the CPU and memory metrics from different T-SQL that ran and finished from the same session.

  • September 26, 2017 at 6:19 am

    #1960931

    coolchaitu - Monday, September 25, 2017 9:00 AM

    Do the sleeping SPIDs consume CPU and memory while they are in sleeping state?

    No. Sleeping means doing nothing waiting for more work. Hence they take no CPU, and only the memory required for the connection itself.

    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

Viewing 3 posts - 1 through 2 (of 2 total)

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