April 1, 2009 at 11:53 pm
Hi,
We have production server. Last Week on March 27th we face Sql Server Hanging issues.
The error in Application Event Viewer is " Hanging Application SQLWb.exe, version ......"
After that we restarted the SQL Server Services. When we check sp_who2 active now itself(Apl 2nd 2009 IST), it shows one of the system process (Checkpoint )is in suspended status.
output of the SP_who2 active
Status - SUSPENDED
Login - sa
HostName - .
BlkBy - .
DBName - master
command - CHECKPOINT
CPU Time - 296234
Disk I/O - 38063
Last Batch - 03/27 14:14:27
Program Name -
SPID - 10
Please let me clarify the about suspended status and what could be root cause of this application hanging issues.
Regards,
S.Balavenkatesh
April 2, 2009 at 12:04 am
Suspended status means that the command is waiting for some other action to be performed so that it can continue.
Checkpoint writes modified pages from the memory on to the disk. Since this is the command that is showing suspended status there is a chance that there may be a corruption in the db.
Iam not very sure on this so pls check out what others (more knowledgeable than me) have to say on this.
"Keep Trying"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply