25 January,2016 by Tom Collins
Question: I’m getting a Flush Cache message in the SQL Server Logs.
FlushCache: cleaned up 3606 bufs with 476 writes in 69033 ms (avoided 4 new dirty bufs) for db 7:0
What does it mean regarding sql server performance? Are there methods I should be using to troubleshoot this message
Answer: The impact on SQL Server performance will depend on understanding the context . Checkpoint logging causes this message to appear in the SQL Server logs. Just to be specific, these messages only started appearing in the logs since 2012. Prior to 2012 you needed to turn on a trace flag,
Typically – I’ve found it to be a combination of : a) the sub storage system not maintaining the throughput required to support the applications and b) higher than usual amounts of data IO. These are broad guidelines and requires some more detailed analysis. Some suggestions to assist in the troubleshooting process.
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |