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