Sample Header Ad - 728x90

Database Cache Memory in Performance Monitor drops down significantly after DBCC CheckDB

8 votes
1 answer
582 views
We have been monitoring some SQLServer: Memory Manager's metrics, and noticed that after DBCC CheckDB job, metric Database Cache Memory (KB) drops down significantly. If to be exact, it dropped from 140 GB cached DB memory to 60 GB. And after that, slowly ramp up again during the week. (Amount of "Free Memory KB", went from 20 to 100 GB right after CheckDB) DBCC CheckDB is run every Sunday, so Database Cache Memory has to ramp up back again each week What is the behavior of this ? Why CheckDB pushes database pages out of memory ? Second question is why "buffer cache hit ratio" did not change after DBCC CheckDB completes ? It was 99.99% on average and after DBCC CheckDB job it drops to ~98.00%, and returns back to 99% pretty fast while I expected "buffer cache hit ratio" to drop significantly because database data has to be read from storage to RAM again ?
Asked by Aleksey Vitsko (6195 rep)
Aug 1, 2019, 07:43 AM
Last activity: Aug 1, 2019, 12:02 PM