Product has been added to your cart.

Search Results for “Ola Hallengren”

How to Configure Ola Hallengren’s Database Maintenance Scripts for Backups

Brent Ozar
Backup and Recovery
17 Comments
Someone told you that you should be using Ola Hallengren’s Maintenance Scripts. You’ve downloaded his Maintenance Solution.sql, you ran it in the master database, and … now you’re not sure what’s supposed to happen next. In this post, we’ll cover how to configure backups. First, configure the Agent jobs. When MaintenanceSolution.sql ran, it created a…
Read More
Ola Hallengren at the PASS Summit 2014

Ola Hallengren’s Maintenance Scripts are Now on Github.

Brent Ozar
Backup and Recovery, Ola Hallengren's Database Maintenance Scripts
2 Comments
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

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

Brent Ozar
Always On Availability Groups, Backup and Recovery, Ola Hallengren's Database Maintenance Scripts
90 Comments
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.…
Read More

How to Configure Ola Hallengren’s IndexOptimize Maintenance Script

Brent Ozar
Index Maintenance, Ola Hallengren's Database Maintenance Scripts
128 Comments
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…
Read More

[Video] Office Hours: The Long One

Brent Ozar
Videos
2 Comments
You posted a lot of great questions at https://pollgab.com/room/brento and I spent almost an hour covering these: Here’s what we covered: 00:00 Start 02:05 Kulstad: I’m using Ola Hallengren’s maintenance scripts for my db maintenance on Saturday evenings, and I’ve noticed my memory consumption go from approx 35% usage during the business week to 85%…
Read More

[Video] Office Hours While the Pool Refills

Brent Ozar
Videos
6 Comments
I step away from the backyard long enough to take y’all’s questions from https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 02:23 Stockburn: Hi Brent, we are using distributed always on AGs, with a node in AWS for DR. We are thinking of using this to quickly migrate the work load to the…
Read More

[Video] Office Hours in Tel Aviv, Israel

Brent Ozar
Videos
2 Comments
Before speaking at the Data TLV Summit, I sat by the Mediterranean Sea and discussed the top-voted questions you posted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:55 Manikandan GS: As postgres being one among the RDBMS lane, do you think postgres is having more features and flexibility compared to MS-SQL Server? 02:46 PaginationWoo!:…
Read More
Office Hours - ask me anything.

[Video] Office Hours: San Diego Office Edition

Brent Ozar
Videos
2 Comments
I’m back in the US at my home studio in San Diego, so I did a live Office Hours session. Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Here’s what we covered today: 00:00 Introductions 00:41 WTF_SQLServer!?!: I have a some dbs that take nearly 6 hours each…
Read More
Brent Ozar's Consultant Toolkit

Updated First Responder Kit and Consultant Toolkit for January 2022

Brent Ozar
First Responder Kit Updates
10 Comments
In this release, sp_Blitz shows some information about clusters and AGs, sp_AllNightLog and sp_DatabaseRestore get some love, and more. Wanna watch me use it? Take the class. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First Responder Kit: Import. PowerShell users: run Install-DbaFirstResponderKit…
Read More

[Video] Office Hours: Ask Me Anything On the Balcony

Brent Ozar
Videos
5 Comments
Good evening, party people! I finally have my new San Diego home base all set up and unpacked, so I took a champagne break to review your top-rated questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:27 Alex: Hi Brent. For a few hours we got a “Could not continue scan with NOLOCK due…
Read More

When You’re Troubleshooting Blocking, Look at Query #2, Too.

Brent Ozar
Locking, Blocking, and Isolation Levels
2 Comments
When I’m troubleshooting a blocking emergency, the culprit is usually the query at the head of a blocking chain. Somebody did something ill-advised like starting a transaction and then locking a whole bunch of tables. But sometimes, the lead blocker isn’t the real problem. It’s query #2. Here’s a sample scenario: A long-running select with…
Read More

08 Partitioning Is a Great Partner for Columnstore

Brent Ozar

To be honest, I’m not a big fan of table partitioning in most scenarios. It’s a data loading & unloading feature thanks to the sliding window scenario, but… most folks just don’t load their data an entire partition at a time. However, when we need to do index maintenance for columnstore indexes, that’s exactly what we…

To access this incredible, amazing content, you gotta get Recorded Class Season Pass or Fundamentals of Columnstore Indexes, or log in if you already shelled out the cash.
Read More

Backups 3: Setting Up Maintenance Plans

Brent Ozar
2 Comments
Developers and sysadmins: the easiest way for you to protect your servers is by using maintenance plans. Full time production database administrators should watch the Ola Hallengren maintenance script setup module instead. I’m specifically targeting this video at developers and sysadmins who need an easy, safe way to protect stuff without knowing T-SQL.
Read More
How I Use the First Responder Kit

Updated First Responder Kit and Consultant Toolkit for February 2020

Brent Ozar
First Responder Kit Updates
0
We spent Valentine’s Day removing the bugs from your chocolates. You’re welcome. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First Responder Kit: Import. Download the updated Consultant Toolkit in your account EU customers: check your email for the updated version from Gumroad,…
Read More
Brent Ozar

Hi! I’m Brent Ozar.

I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too.

Want to advertise here and reach my savvy readers?