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.
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