Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dev2dev
Starting Member
48 Posts |
 Posted - 2008-04-16 : 10:17:44
|
| Hello,I am DB Developer (not admin), excuse me if this is a silly question.I don't know much about CHECKPOINT background But I feel, this process is slowing down performance of my sps which runs slower than normal in some cases.Especially when I see any of my process goes in the suspended mode and its wait type is SLEEP_BPOOL_FLUSH and CHECKPOINTs process is also suspended and its wait type is CHECKPOINT_QUEUE.More important anything else is... this background process (which I always find its spid is 11) BLOCKS all other user processes when it goes into suspended mode and its wait type is SLEEP_BPOOL_FLUSHI dont know my analysis is correct (claiming checkpoint as culprit), need experts advice and helpcan someone give info on checkpoint and how this effect server performance |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-16 : 16:19:15
|
| Did you check what statement that spid is running? DBCC inputbuffer(spid).? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-16 : 22:27:01
|
| Checkpoint is system process that freshs changed data from memory to disk. Check disk i/o on the server, may need faster storage. |
|
|
|
dev2dev
Starting Member
48 Posts |
Posted - 2008-04-17 : 08:58:46
|
| how often this process runs? I am curious to know when it goes into SLEEP_BPOOL_FLUSH wait type. Because always i seen this process in this wait type blocks all other my process |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-17 : 22:46:19
|
| Every minute by default. SLEEP_BPOOL_FLUSH occurs when a checkpoint is throttling the issuance of new I/Os in order to avoid flooding the disk subsystem, seems disk bottleneck. |
|
|
|
|
|
|
CHECKPOINT backgroup process