Ola Hallengren

ola hallengren index optimize not optimizing indexes

by

We had deployed ola hallengren maintenance solution for one of the customers and scheduled all the jobs. Customer mentioned to us that Index Optimize job ran fine, however he could still see that there were many indexes with fragmentations percentage around 90% and more. He even sent report for this as evidence. Then we went … Read more

Ola hallengren Index maintenance – Optimal way to use it

by

This code will execute IndexOptimize stored procedure and will reorganize or rebuild indexes based on default fragmentation values ( i.e., 5 and 30% – rebuild). However, this will not update statistics as default set to null.