Index optimization

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

SQL Server Performance Tuning : Ways to do Index Optimization

by

In our last post we discussed an approach on what we should do to find whether there is a memory issue or a way to identify if there is a memory crunch which is causing bad SQL performance. However, not always the thing we see on the surface is the root cause. Though there may … Read more