Field Testing Ola Hallengren’s Maintenance Solution

I work as part of a team that has worked on thousands of installations of Ola’s famous scripts, which is the most common way of running maintenance on a SQL Server instance. As a huge fan of this solution I have immersed myself in its use, and have many practical insights to get the best out of this incredibly useful resource.

The scripts out of the box work beautifully and have transformed many a SQL Server, but, how do you get the best out of them? What are the lessons learnt from spending all these years working with this solution on hundreds of different customer sites?

What you will learn from this session (no experience needed):
- Best practices for installing and upgrading
- Scheduling and splitting the jobs for best effect
- Which configuration options to use, and which to be careful with
- Troubleshooting job failures efficiently, and finding the root cause even in a complex environment

This is a practical session where we will walk through installing, configuring, and troubleshooting. You will be able to go back to your servers and implement this with a much better level of understanding and techniques to troubleshoot.

Feedback link:

Starts: 11:30 10th Mar 2022
Ends: 11:50 10th Mar 2022


Short Description
- Learn how to best configure and use Ola's Maintenance Solution, based on years of experience using this on thousands of SQL Server instances.

Slidedeck Link

Field Testing Ola Hallengren’s Maintenance Solution.pptx


Joe Pollock


On PremisesIAAS VM BasedDataOpsManagingDatabase EngineBeginnerHow

The SQL Bits Story

SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.

As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.

15 Years

We’ve grown and expanded a lot since 2007.

2500 Participants

SQLBits is the best place to meet fellow data professionals.

82 Countries

We welcome data professionals from all over the globe.

1140 recorded sessions

All the live sessions are recorded and offered for free, year round.

Experience the SQLBits Conference


Want to be part of the SQLBits community?

Attend the London conference in-person or virtually on 

March 8-12, 2022 at ExCel London, UK.