SP_WHO2

Hi,
When SP_who2 is run,can it get the data from two weeks back or how is the time period determined?
is there a way to control the reult set time period? what does status RUNNABLE and Commands-- TASK Manger,AWAITING COMMAND,CHECKPOINT SLEEP mean?
crishna1Asked:
Who is Participating?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
The limit it's the last time SQL Server service was restarted.
It will show you the current connections. If you have SPID's from 4-5 months ago, that means they was never disconnected. Maybe those are system processes (usually low process number).
0
 
crishna1Author Commented:
Alos, by running sp_who or sp_who2 has a chance of corrupting the database , is that true?
0
 
crishna1Author Commented:
i found the answers for various stages in status i asked in my question, now i need to know,
1)When SP_who2 is run,can it get the data from two weeks back or how is the time period determined?
2)by running sp_who or sp_who2 these is a chance of corrupting the database , is that true??
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Answer for your questions:
1) Those SP's gives you a snapshot of the moment you execute them. It's always about the present so you can't have data from a determined period.
2) False. Those SP's wouldn't corrupte databases. No chances at all for that.
0
 
crishna1Author Commented:
on question #1
how far back does it go and how is the time period based on or determined?  when i execute SP_WHO2 on one of my servers i see login/SPID's from 4-5 months back.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.