SQLBits 2022

Field Testing Ola Hallengren’s Maintenance Solution

Learn how to best configure and use Ola's Maintenance Solution, based on years of experience using this on thousands of SQL Server instances.
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: https://sqlb.it/?7125