Categorie Ola Hallengren

Blocking & Locking, Ola Hallengren, Performance Tuning

Index Maintenance .. the good, the bad and you decide if it’s ugly..

Ola Hallengren does a great job with his IndexOptimize ( SQL Server Index and Statistics Maintenance ). . Discussion note from working through Jeff Moden’s ( (10) Jeff Moden | LinkedIn ) “Black Arts Index Maintenance #1.2 – GUIDs v.s.…

Ronald de Groot
11 september 2026

Ola Hallengren

IndexOptimize and addition’s to Ola Hallengrens dbo.CommandLog

Of course you run Ola Hallengren’s IndexOptimize ( SQL Server Index and Statistics Maintenance ) as a job in the weekend with your own custom @FragmentationLevel1 and @FragmentationLevel2 levels and suddenly the jobs takes much longer to run.. why? Well…

Ronald de Groot
17 april 2026
1 reactie