September 3, 2013 at 3:48 am
Hi all
Lately I've seen some messages about long checkpoints in our server. The messages look like this:
FlushCache: cleaned up 311 bufs with 275 writes in 100497 ms (avoided 7 new dirty bufs) for db 4:0
average throughput: 0.02 MB/sec, I/O saturation: 3139, context switches 6607
last target outstanding: 2, avgWriteLatency 627
I understand parts of this message. I do understand that the checkpoint had to write 311 pages and it did it by issuing 275 reads operation. This took 10004.97 seconds. The throughput was 0.02 mb/sec (kind of shocking, I think that hand writing can be quicker). What I don't understand is the other parts of this message (e.g. I/O saturation: 3139, context switches 6607 last target outstanding: 2, avgWritLatancy 627). Any explanation about this part would be greatly appreciated.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy