Ola Hallengren’s Database Maintenance Scripts

sp_AllNightLog: ¿Por que los queues?

Last Updated July 7, 2017

Backup and Recovery, Clients and Case Studies, ISV and SaaS Database Design, kCura Relativity, Ola Hallengren's Database Maintenance Scripts

Building stuff I sometimes really hate coming up with ideas, and much prefer someone to just say “I want this” so I can go out into the world and figure out how to do that. Occasionally though, I realize that I’m not going to get all that much direction. That’s what happened with sp_BlitzQueryStore. It…

Ola Hallengren’s Maintenance Scripts are Now on Github.

Last Updated June 17, 2017

Brent Ozar

Backup and Recovery, Ola Hallengren's Database Maintenance Scripts

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…

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

Last Updated June 17, 2017

Erik Darling

Index Maintenance, Ola Hallengren's Database Maintenance 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…

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

Last Updated March 6, 2019

Brent Ozar

Always On Availability Groups, Backup and Recovery, Ola Hallengren's Database Maintenance 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.…

How to Configure Ola Hallengren’s IndexOptimize Maintenance Script

Last Updated April 14, 2023

Brent Ozar

Index Maintenance, Ola Hallengren's Database Maintenance Scripts

128

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: Transact-SQL CREATE PROCEDURE…