October 13, 2015 at 1:26 pm
Hi,
When I am going through the SQL Server Error logs, I saw below messages
What are these messages means? Is this need some thing to be worried. I can see the db is one of our user db and some times, I can see some times db 9( reportservertempdb) also
Is some thing related to IO issue? We are getting blocking more frequently
FlushCache: cleaned up 23952 bufs with 19952 writes in 64554 ms (avoided 9383 new dirty bufs) for db 8:0
average throughput: 2.90 MB/sec, I/O saturation: 60, context switches 8141
last target outstanding: 141600, avgWriteLatency 0
October 13, 2015 at 1:42 pm
It's normal. See here:
How It Works: When is the FlushCache message added to SQL Server Error Log?
Gerald Britton, Pluralsight courses
October 13, 2015 at 3:49 pm
We don't have traceflag enabled
October 13, 2015 at 4:02 pm
Did you read the whole article? You don't need to trace flag in sqll server 2012
Gerald Britton, Pluralsight courses
October 14, 2015 at 9:30 am
I can see our configured value for "Recovery interval" = 0. i.e. I am thinking the checkpoint occurs by default 1 min.
October 14, 2015 at 9:36 am
With a default recovery interval, SQL tries to keep the estimated recovery time under 1 minute, you get checkpoints about every minute for active databases, can be less often for DBs that are idle.
But regardless, the cache flush messages are normal, added as default in SQL 2012. They're just informational messages about how much the checkpoint is writing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2015 at 9:49 am
This DB is very active all the time.
If it is informational message then I have to see this message frequently because checkpoint occurs every 1 min, but I can see this message recently and also just couple of time per day and some days not yet all.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply