Replies: 1 comment
-
|
IndexOptimize do not rebuild heaps. I got my own take on this: https://github.com/Stiffboard/AdminDBA/blob/main/2.7-HeapMonitorAndRebuild.sql |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
I have updated IndexOptimize script to include Heap maintenance following Brent Ozar’s recommendations for fixing forwarded records.
https://www.brentozar.com/archive/2016/07/fix-forwarded-records
IndexOptimize is excuted weekly as:
However it seems like Heaps are not rebuilded due to high forwarded record counts of Heaps.
I suspect I might be missing a specific parameter or threshold setting. Could someone review my execution logic or suggest if I need to adjust the fragmentation levels to trigger a rebuild on these Heaps?
Beta Was this translation helpful? Give feedback.
All reactions