Tag Archives: Maintenance

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

Gracefully shutdown SQL Server, stop accepting new connections

During maintenance activity we try to bring down SQL server gracefully without impacting existing transactions and not accepting new connections. One of the best options to accomplish this is to PAUSE SQL Service using SQL Server configuration Manager. Pausing SQL … Continue reading

Posted in Productivity, SQL | Tagged , , , , , | Leave a comment