Search Results for “Ola Hallengren”

DBCC CHECKDB Not Run Recently

Last Updated July 27, 2020

When SQL Server writes data to your drives, it just assumes everything’s okay until it needs to read the data back again. Unfortunately, in the event of storage corruption, the storage isn’t so kind as to alert SQL Server. And sometimes, SQL Server has even been known to corrupt itself. We need to periodically check…

Backups Gone Bad: The Danger of Differentials

Last Updated February 13, 2017

Brent Ozar

Backup and Recovery, SQL Server

As your databases get bigger, you’re going to run out of time to do nightly full backups. You’re going to be tempted by the siren song of differential backups. The idea is that you’ll do full backups on the weekends, and then differential backups each night of the week. Differential backups aren’t just the sum…

Stop Worrying About SQL Server Fragmentation

Last Updated March 5, 2017

Brent Ozar

Index Maintenance, SQL Server

138

I bet you’re worried about your index fragmentation. If your database was a phone book, it would look like this one. And I bet you’re wasting your time, missing the real point. What is Index Fragmentation and How It Happens Let’s take a step back for a second and pretend that your database is a…

The SQL Server Performance Checkup from a Consultant’s Perspective

Last Updated March 26, 2014

Jes Schultz

SQL Server

Here at Brent Ozar Unlimited®, we offer a server performance checkup to clients. As the newest member of the team, I wasn’t sure what to expect when running one. I found out that it’s pretty cool. I pretend we’re Special Forces operatives, strapped into our parachutes, doing a HALO opening over client servers. (This homemade parachute…

SQL Server RDS

Last Updated February 13, 2017

Jeremiah Peschka

Amazon Web Services (AWS), SQL Server

Amazon Web Services (AWS) is a platform that offers a ton of services ranging from block storage, operating systems, to mail queues, DNS, and caching. When you say “cloud”, a lot of people think of AWS. AWS hosts a variety of businesses, large and small. Unfortunately, you still have to administer and configure your servers.…

Maintenance Plans and Roombas Suck – in a Good Way

Last Updated February 9, 2017

Brent Ozar

Backup and Recovery

Every now and then, I hear an experienced DBA say, “SQL Server maintenance plans for backups, indexes, and statistics? What, are you kidding me? Nobody uses maintenance plans because they suck.” They say maintenance plans are so inflexible because they insist on defragging or rebuilding every index, every time, regardless of how little the table…

Full Recovery Model Without Log Backups

Last Updated July 27, 2020

Brent Ozar

Full Recovery Model Without Log Backups When a database is in Simple Recovery Model, SQL Server does circular logging: it goes back to the beginning of the transaction log and reuses space when it can. Portions of the log are freed up when they’re not covering open transactions. Circular use of the transaction log file…

Backups Not Performed Recently

Last Updated October 23, 2020

Brent Ozar

Backups Not Performed Recently Errr…… Before we start working on anything, we need to know all our user databases are getting backed up. We check to see if there’s been a full backup in the last 7 days. Often, someone set up maintenance plans to back up specific databases by checking their names. They checked…

Index Fragmentation Findings: Part 1, The Basics

Last Updated July 13, 2017

Brent Ozar Unlimited Team

Index Maintenance, SQL Server

We asked the community for index fragmentation information for data mining purposes, and the results are in – and interesting. Over the next couple of weeks, I’ll talk about some of the results we found in the field. What Is SQL Server Fragmentation? SQL Server stores data in pages. To make things easy, think of…

What SQL ConstantCare® Looks For

Last Updated July 27, 2020

Brent Ozar

“This server’s plan cache smells terrible.” SQL ConstantCare® analyzes your data looking for health and performance issues that cause user pain. Here are the things we check for and the number of servers where we found this problem this month: Backup Back Up Your TDE Certificate – 137 servers affected CRITICAL: Take a Full Backup…

An Idea For Improving DBCC CHECKDB

Last Updated January 2, 2019

Erik Darling

CHECKDB and Corruption

Hard Enough At this point, we’ve all probably got a database that’s a terabyte or more in size. If you’re anything like I was, you’ve got a ton of multi-terabyte databases, and the SAN admin has a special folder for your emails. When you’ve got a lot of large databases, normal maintenance is out the…

[Video] Office Hours 2018/1/10 (With Transcriptions)

Last Updated January 18, 2018

Brent Ozar Unlimited Team

SQL Server, Videos

This week Brent, and Richie discuss validating backups using the backup set table, how to figure out if you’re a Mid-Level or Senior DBA, rollbacks, compatibility modes while upgrading SQL Server versions, MAXDOP settings, and Brent’s car purchasing tip. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our…

Maintenance Plans Enable Your Disabled Indexes

Last Updated December 16, 2017

Tara Kizer

SQL Server

One of Brent’s students in the Performance Tuning class, Jason M., told Brent that maintenance plans enable your disabled indexes. What the what? Steps to reproduce: Disable an index Setup a maintenance plan to rebuild all indexes Run the job Check if the index is disabled or enabled. Steps 1 and 2 can be reversed…

sp_AllNightLog: ¿Por que los queues?

Last Updated July 7, 2017

Erik Darling

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…

Questions You Should Be Asking About Your Backups

Last Updated February 9, 2017

Erik Darling

Backup and Recovery, SQL Server

#basicbackup So you’re taking backups! That’s great. Lots of people aren’t, and that’s not so great. Lots of people think they are, but haven’t bothered to see if the jobs are succeeding, or if their backups are even valid. That’s not great, either; it’s about the same as not taking them to begin with. If…

Why Not Just Create Statistics?

Last Updated February 13, 2017

Erik Darling

Indexing, SQL Server, Statistics

Here at Brent Ozar Unlimited We have a proud tradition of not blaming index fragmentation for everything. There are points you should deal with it, but they’re probably not 5% and 30% and 1000 pages. But that’s not what this blog post is about. I’m hoping to clarify why we’re more interested in up to…

Availability Group Direct Seeding: Mind Your Backup Jobs

Last Updated February 9, 2017

Erik Darling

Always On Availability Groups, Backup and Recovery, SQL Server

I’ll get right to the point While you’re Direct Seeding, you have to be careful with any other full or differential backup jobs running on the server. This is an artifact of the Direct Seeding process, but it’s one you should be aware of up front. In the screencap below, courtesy of sp_whoisactive there’s a…

SQL Server 2005 End Of Support: Keep Calm And Do This Stuff

Last Updated February 23, 2016

Erik Darling

SQL Server

Ask not for whom the bell tolls It tolls for SQL Server 2005. Which means in a few short months, you’ll need to get out of Dodge. I’m sure you all have your upgrade ducks in a row, you’ve studied the breaking changes, the upgrade path, and maybe even downloaded the latest upgrade advisor. Smarty…

UPDATE STATISTICS: the Secret IO Explosion

Last Updated February 13, 2017

Kendra Little

Index Maintenance, SQL Server, Statistics

I first knew something was up when I looked at the job history for a simple maintenance plan. It had two steps: Rebuild all the indexes in the database – this took 10 minutes each night. Update statistics – this took 2-3 hours each night. What was going on? Statistics in SQL Server are small,…

5 Things About Fillfactor

Last Updated February 13, 2017

Kendra Little

Index Maintenance

Are you a page half full, or a page half empty kind of person? I’ll never think “I’ve seen it all” when it comes to SQL Server– there’s just always someone waiting around the corner who’s found a weird new thing to do with it. But there are some things I really wish I could…

Search Results for “Ola Hallengren”

Hi! I’m Brent Ozar.