Q: If they are in sleeping mode yet can they be a reason of
A: Sleeping means waiting for a event to occur. At any given
point in time there can be multiple connections in sleeping
mode as they will be waiting for IO, CPU, MEMORY etc.
The thing is we need to identify which resource is
which is waited most.
A sleeping connection is one that is not running a query at the moment. If a connection is running a query and is waiting for a resource (lock, memory, IO) it will be SUSPENDED. If it is waiting for time on the CPU it will be RUNNABLE. If it is currently executing it's status will be RUNNING
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