May 13, 2008 at 4:17 pm
Hi me again
I was executing PSSDIAG on one of our heavy volume OLTP platforms and found the following block information in the blocker script
Date Time = 2008-05-09 10:02:14.263 Interval = 389.936 seconds
Blocked Spids = 52,53,64,75,131,202,108
Number Of Head Blockers = 1
Spid 7 is blocking ??? --> Row not found in Sysprocesses
Last Query =
Sysprocesses Details
Command = CHECKPOINT
Open Transaction = 0
Status = runnable
Wait Resource =
Wait Time = 0
Wait Type = Not currently waiting on anything (0x0000)
Last Wait Type = WRITELOG
Resource Details
CPU = 0
Last CPU = 0
CPU Difference = 0
Physical IO = 184974
Last Physical IO = 184974
Physical IO Difference = 0
Memory Usage = 0
Last Memory Usage = 0
Memory Usage Difference = 0
I understand that this is a in the runnable queue and not the running queue. I am suspecting that the CHECKPOINT is causing the block ? .
I understand that the recovery model can play a huge part in CHECKPOINTS and it is currently on simple recovery. The CHECKPOINT can also be affected by latches and if the the log bytes flushed and the disk writes of the CHECKPOINT cannot fit into a 8 kb page (still trying to get more details on this from sql 2000 and 2005 IO basics)
Any comments will be appreciated.
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply