May 27, 2009 at 4:17 am
sp_who and sp_who2 commands which are used to get info about processes and their status...
they will return different status... can anyone write out here or any document you guys can provide about these status i will be thank full...
these commands return status like
1. Sleeping
2. Background
3. Runnable and so on.....
May 27, 2009 at 5:05 am
Background : background threads like logwriter .You cant find what its doing
Runnable : are the ones waiting for their turn to run on CPU .So , actually waiting because other thread is running and SQL is non-preemptive.
Running : currently running
Sleeping : task is done and the spid is still open waiting for the next command
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
May 27, 2009 at 5:05 am
use this : http://technet.microsoft.com/hi-in/library/cc966413(en-us).aspx
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
May 27, 2009 at 5:11 am
thanks abhay that helps!!! ...... 🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply