sql-server-maintenance-solution icon indicating copy to clipboard operation
sql-server-maintenance-solution copied to clipboard

Enhance Index Rebuild Decision Process with Page Density Factor

Open mfuller333 opened this issue 1 year ago • 0 comments

Request to incorporate the page density (avg_page_space_used_in_percent) as a determining factor in deciding whether or not to rebuild the index. Given that we are using modern solid-state drives, fragmentation alone does not provide a comprehensive view of our system’s state. By considering page density, we can make more informed decisions about index rebuilds, leading to improved system performance and efficiency.

mfuller333 avatar Jun 05 '24 22:06 mfuller333