September 3, 2007 at 10:39 am
Hi Experts,
When i execute sp_help at any point of time, I will see the following output.
Can anybody explain me what it means ?
LAZY WRITER
LOG WRITER
SIGNAL HANDLER
LOCK MONITOR
TASK MANAGER
TASK MANAGER
CHECKPOINT SLEEP
TASK MANAGER
TASK MANAGER
TASK MANAGER
TASK MANAGER
TASK MANAGER
TASK MANAGER
TASK MANAGER
SELECT
AWAITING COMMAND
Regards
Karthik
karthik
September 3, 2007 at 10:44 am
Sorry , i am getting the above words in the 'cmd' column.
karthik
September 3, 2007 at 12:26 pm
Some of these are system processes (Task Manager, etc.) so there's nothing to do with these. The Awaiting Command ones are usually idle client connections.
September 3, 2007 at 11:29 pm
The SPIDs numbered 1-50 are reserved by SQL Server for internal use, so all user processes will be 51 or higher.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply