Monthly Archives: September 2018

What are default Index Maintenance settings in Ola hallengren maintenance solution

Summary: When Fragmentation < 5%, No maintenance When Fragmentation >= 5% and Fragmentation < 30 %; index ReOrganize When Fragmentation >= 30%; index Rebuild (If Supported online or Offline) Note: This is the default and regular scenario. check reference for … Continue reading

Posted in SQL, SQL Server, Uncategorized | Tagged , , , , | Leave a comment