Friday, August 03, 2007 2:20 PM
Is there any place I can look for a list of all the possible values in the cmd column when I run sp_who, and an explanation of what each one means. Everyone once in a while I catch a new command in there and I never know where to look for a concise explanation.
Friday, August 03, 2007 4:21 PMModerator
Books Online, Topic: 'sp_who', goes into great detail. -Who'd ever thought of that one.
Also, for a quick 'refresher', you can use sp_help:
EXECUTE sp_help 'sp_who'
Saturday, August 04, 2007 12:16 AMModerator
Arnie is correct, SQL Server Books Online is typically the best place to start when looking for reference material such as commands and statements (what they do, available options, examples, etc.). I recommend downloading the latest version of Books Online (http://www.microsoft.com/downloads/details.aspx?FamilyID=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&mg_id=10124&displaylang=en) or if you prefer online access, try out the Books Online search tool here: http://search.live.com/macros/sql_server_user_education/booksonline.
Monday, August 06, 2007 2:20 AM
Thanks, I agree BOL is a great place to start...and I started there . I've looked several times in BOL and never found the answer to this question. BOL, in my opinion, does not go into great detail regarding this topic. Maybe I didn't explain it correctly (or maybe I am just not reading correctly).
sp_who returns a column, cmd, with various values, for instance:
TRACE QUEUE TASK, RESOURCE MONITOR, UNKNOWN TOKEN, etc.
Most of the time they are fairly self explantory, but sometimes, like Trace Queue Task, I don't understand what that means or why its there. I am looking for a resource that can say Trace Queue Task means the database engine is <Insert answer here>.
BOL, these fourms, and even google all fail to provide a definition.
Maybe a list like that doesn't exist?
Monday, August 06, 2007 3:47 AMModerator
You're right. The detail about what these enumerations mean is severely lacking.
I encourage you to offer a suggestion/request/complaint at:
Suggestions for SQL Server
And if it helps, you might look at the Trace Architecture in the diagram at:
Tuesday, September 22, 2009 8:49 AM
Having just googled the same thing (should I be bing-ing instead? Would that get better results), I found this link, which does at least tell us that 'Trace Queue Task' is an internal process.... which is better than nothing. Or rather, means I can tell the Data Admin manager that this is not a profiling trace and he can Stop Worrying.
Tuesday, January 24, 2012 9:28 AM
Being a moderator, I am trying to be gentle here, you suggest this without verifying the question - he is asking for command column options and its details... you gave this *pretty* answer...
I wish better answers and better links out of this forum... this is not like MYWISH dot com...
( I have no words! )
Tuesday, January 24, 2012 9:30 AM
this question been answered by socalled intellectuals, its been 5years, its the same level of lame documentation....
S*EW YOU MS SQL LEADERS!!
Wednesday, January 25, 2012 6:21 AMBetter article for this would be http://support.microsoft.com/kb/224453?WT.mc_id=aff-n-in-loc--pd