sleeping SPIDs consume CPU and memory ?

• coolchaitu

  SSChampion

  Points: 10334

  More actions

  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?

• Arsh

  SSCertifiable

  Points: 6354

  More actions

  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.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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