Launch week: the Season Pass & Fundamentals Week are 50% off — ends in 19d 22h 34mSee the sale

Category: Ola Hallengren’s Database Maintenance Scripts

Production DBA

Ola Hallengren’s Maintenance Scripts are Now on Github.

For some of you, the headline is self-explanatory, and you just want the URL, so here it is: https://github.com/olahallengren/sql-server-maintenance-solution For the rest of you, here's what it means. What are Ola Hallengren's maintenance scripts? Ola Hallengren's maintenance scripts are a widely used replacement for maintenance plans. His backup, integrity check, and index optimization stored procedures are…

Read more about Ola Hallengren’s Maintenance Scripts are Now on Github. 2 comments — Join the discussion

Stats Week: Only Updating Statistics With Ola Hallengren’s Scripts

I hate rebuilding indexes
There. I said it. It's not fun. I don't care all that much for reorgs, either. They're less intrusive, but man, that LOB compaction stuff can really be time consuming. What I do like is updating statistics. Doing that can be the kick in the bad plan pants that you need to get things running smoothly again.

Read more about Stats Week: Only Updating Statistics With Ola Hallengren’s Scripts 46 comments — Join the discussion
Production DBA

How to Configure Always On AG Backups with Ola Hallengren’s Scripts

With SQL Server AlwaysOn Availability Groups, you can offload backups to a replica rather than running them on the primary. Here's how to do it:

1. Install Ola Hallengren's utility scripts on all of the replicas. During the install, it creates a laundry list of SQL Agent jobs, but doesn't set up schedules for any of them. More on that in a couple of steps.

Read more about How to Configure Always On AG Backups with Ola Hallengren’s Scripts 91 comments — Join the discussion

How to Configure Ola Hallengren’s IndexOptimize Maintenance Script

If you're a production database administrator responsible for backups, corruption checking, and index maintenance on SQL Server, try Ola Hallengren's free database maintenance scripts. They're better than yours (trust me), and they give you more flexibility than built-in maintenance plans.

However, the index maintenance defaults aren't good for everyone. Here's how they ship:
[crayon-6a373d54f1c20231237127/]
The defaults on some of these parameters are a little tricky:

Read more about How to Configure Ola Hallengren’s IndexOptimize Maintenance Script 138 comments — Join the discussion