Product has been added to your cart.

Search Results for “sp_blitz”

Office Hours, Text Edition: No-Brainer Questions

Last Updated April 26, 2022

Production Database Administration

For my Office Hours streams on my Twitch channel, y’all post questions at PollGab and upvote the ones you’d like to see me discuss on the stream. However, not all questions require a video answer. Here are some simple no-brainer ones: Q: BehindTheScenesDBA: With all its limitations, what do you think about memory-optimized tables? Have you…

What Do the LCK_M_SCH_M and LCK_M_IS Wait Types Indicate?

Last Updated April 9, 2022

Locking, Blocking, and Isolation Levels, Wait Stats

You’re investigating your SQL Server’s top wait stats, and you’re noticing a lot of LCK% waits. Normally, that indicates blocking and deadlocks, but you’re just not getting complaints from your end users, and you’re wondering what’s causing it. It might be overzealous index rebuilds. Let’s demo why by starting a new query in the Stack…

Updated First Responder Kit and Consultant Toolkit for April 2022

Last Updated April 8, 2022

First Responder Kit Updates

Wow, talk about stable! The last 3 months have only introduced a series of small bug fixes. I held this release back as long as I could, waiting to see if anything major might get added or if we might get a SQL Server 2022 CTP, but no dice. If there was ever a First…

Office Hours - ask me anything.

[Video] Office Hours: San Diego Office Edition

Last Updated March 24, 2022

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…

[Video] Office Hours: Ask Me Anything at Sunset on the Balcony

Last Updated March 21, 2022

Ah, sunset – time to kick back on the balcony, watch the ocean, and discuss SQL Server. You post questions at https://pollgab.com/room/brento/, upvote the ones you’d like to see me answer, and I discuss ’em: 00:00 Introductions 00:30 iAmGroot: Hello Brent, my friend has a VLDB and he’s asking what is a good strategy to…

SQLDay Poland Workshop: How I Use the First Responder Kit

Last Updated March 18, 2022

Conferences and Classes

Watch and learn I’m presenting remotely at the upcoming SQLDay Poland on 9-11 May! I’m teaching a one-day workshop, How I Use the First Responder Kit. You’ve downloaded sp_Blitz, sp_BlitzIndex, and sp_BlitzCache from the First Responder Kit, and you’ve run them a few times. You know there’s a ton of advice in there, but…it’s kinda…

[Video] Office Hours: Morning in Mexico Edition

Last Updated March 10, 2022

Got SQL Server questions? Post ’em at https://pollgab.com/room/brento and upvote the questions you’d like to see me discuss. Here’s what we covered this morning: 00:00 Introductions 00:45 SQL Simian: Everybody loves free advice, but we want war stories. I have heard your 174 indexes story twice now during recorded classes. Got any more? What are…

SQLBits 2022 Day 1 Keynote

Last Updated March 10, 2022

Conferences are back, baby! I’m in London for SQLBits 2022, the biggest Microsoft data conference in Europe. This year’s theme is classic video games, and it’s been really cool to see the 8-bit logos and games all over the ExCel Center. Today is the Microsoft keynote. It’s called Level Up with Azure Data, hosted by…

[Video] Office Hours: Cabo Home Studio Edition

Last Updated February 24, 2022

Got questions about SQL Server? Post them at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. This episode was the first live one I shot in my home studio in Cabo: Here’s what we covered: 00:00 Introductions 02:19 Nullpointer: What are your thoughts on temporal tables, I don’t hear you talk much…

[Video] Office Hours at Sunrise (No Really)

Last Updated February 4, 2022

I’ve got a really sensitive lens (Sigma 16mm f/1.4) on my camera, so often when I record these at sunrise, it’s already too bright for you to see the sun. This time, I went down to the beach a little earlier, and through the video, you can see the light really pick up. Here’s what…

Office Hours - ask me anything.

[Video] Office Hours: Ask Me Anything About SQL Server in Cabo

Last Updated January 27, 2022

I watched the sun rise from my balcony in Cabo this morning and answer your questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:42 Student: Hi Brent! Why is full backup sometimes slow and sometimes fast in similar situations? This problem will be resolved after restarting the server but it comes back again. 02:58…

[Video] Office Hours: Ask Me Anything About SQL Server

Last Updated January 17, 2022

Let’s pick up right where we left off yesterday. I’ve got more time and champagne, so let’s keep going through your top-voted questions from PollGab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:39 Wilma: Poor code & tuning issues. Evidence = Database Performance Analyzer & sp_blitz. App is the customer’s idea. The dev has got golden…

Office Hours - ask me anything.

[Video] Office Hours: Ask Me Anything About SQL Server

Last Updated January 17, 2022

I’m back in San Diego, so let’s sit out on the balcony, enjoy a tasty beverage, and go through your top-voted questions from PollGab.com/room/brento. Here’s what we covered: 00:00 Carl: Hi Brent, what is your opinion of the graph db support starting in SQL2017? Is this another doomed SQL feature? 02:06 Bob: Brent, sometimes when…

Brent Ozar's Consultant Toolkit

Updated First Responder Kit and Consultant Toolkit for January 2022

Last Updated January 8, 2022

First Responder Kit Updates

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…

[Video] Office Hours in Cabo: Ask Me Anything About SQL Server

Last Updated January 2, 2022

Let’s get together at sunrise in Cabo San Lucas, Mexico and talk through your highest-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:33 AtHomeWithCOVID: Historical advice is to spread multiple datafiles/filgroups across disks. Now, storage is allocated from a balanced SAN as one drive, e.g “D” data, “L” Logs Are there any gains…

New Year’s Resolution: Lose Weight in Your Database

Last Updated January 5, 2022

Made a New Year’s resolution to lose weight this year? Forget taking it off your waistline – take it off your database instead with: sp_BlitzIndex @GetAllDatabases = 1, @Mode = 2, @SortOrder = ‘size’ Or: sp_BlitzIndex @GetAllDatabases = 1, @Mode = 2, @SortOrder = ‘rows’ This produces an inventory of all the indexes sorted by…

[Video] Office Hours: SQL Server Q&A in Cabo at Sunrise

Last Updated December 15, 2021

Let’s watch the sun rise at Land’s End and cover your top-voted questions from https://pollgab.com/room/brento/. Here’s what we covered: 00:00 Introductions 01:04 Jr Wannabe DBA: Hi Brent, a colleague wants to upgrade from Standard to Enterprise purely for performance gains on several regular servers (up to 8 CPU, 128GB of RAM, SQL 2016 or 2019).…

[Video] Office Hours: Black Friday Edition, Ask Me Anything About SQL Server

Last Updated November 27, 2021

Yesterday, I finished setting up my new Apple MacBook Pro with the new M1 Max processor and did its first live stream on my Twitch channel to see how the hardware held up. I was tickled pink – worked great! Here’s what we covered: 00:00 Introductions 03:48 TheGreatFode: Hi Brent, have you ever seen cases…

[Video] Office Hours on the Balcony Part 2

Last Updated November 18, 2021

Picking up right where we left off yesterday, we continue down through the not-so-highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:22 Andrew from Canada: To Null or not to Null? That is the question. On tables with 100M to 1B rows and with several columns that contain data 20% of the time, should…

And it looks bad even in shades.

NOLOCK Is Bad And You Probably Shouldn’t Use It.

Last Updated November 18, 2021

Locking, Blocking, and Isolation Levels

I’m waiting for the YOLOck option. When you put NOLOCK in your query, SQL Server will: Read rows twice Skip rows altogether Show you changes that never actually got committed Let your query fail with an error This is not a bug. This is by design. To understand what happens, read these blog posts in order:…