Search Results for &#8220;sp_blitz&#8221;

I sat down on the edge of Brooklyn, overlooking the Manhattan skyline, to take your highest-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:42 Dylan: Do you have any experience with sys.dm_db_tuning_recommendations? To be clear, I am not referring to Azure SQL or Automatic Index Tuning, but rather Query Store Forcing/Unforcing plans automatically.…

5 Ways to Measure a Query

Last Updated November 1, 2021

Execution Plans

In my free How to Think Like the Engine class, we start out by measuring query performance using logical reads. That’s the number of 8KB data pages that SQL Server has to read in order to find your query’s results. That’s the measure I use the most because generally speaking, the less data your server…

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

Last Updated October 19, 2021

I’m up bright and early in Malibu, so let’s talk through your highly upvoted questions from https://pollgab.com/room/brento. 00:00 Introduction 01:04 JD: Have you ever encountered a very weird case during query / performance tuning that you just couldn’t get the query across the finish line, specifically just because SQL Server didn’t want to behave nicely?…

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

Last Updated October 8, 2021

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…

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

Last Updated September 17, 2021

The beach at Vestrahorn mountain looks different every time we’ve visited: high tide, low tide, sun, clouds. Always a fun side trip when we’re out in the southeast of Iceland. I took a break to answer the questions you upvoted here. Questions we covered: 00:00 Introductions 00:38 Scott M: When do you recommend sp_BlitzWho vs…

Updated First Responder Kit and Consultant Toolkit for September 2021

Last Updated November 6, 2021

First Responder Kit, First Responder Kit Updates

I’ve slowed the First Responder Kit update frequency down to once every 2 months. I know from firsthand experience working with clients that folks just can’t patch quickly enough, hahaha. Folks who want to be on the bleeding edge updates can always use the dev branch in Github, too, getting every new fix the moment…

[Video] Office Hours: Ask Me Anything About SQL Server at Hallgrímskirkja

Last Updated September 3, 2021

I hang out by Hallgrímskirkja, the modern church in Reykjavik, and take your highly-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:18 __normally_weird (Sean C): Can you dispel the now prevailing myth that you and your wife are the only8 people in Iceland at the moment? 01:33 Andy Leonard: What “bugs” exist in…

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

Last Updated August 20, 2021

In this episode, I’ve got my own question: what’s this animal running around at my feet? Commenters on the YouTube video explained that it’s a mink. They were imported into Iceland in the 1930s for their fur, and they escaped out into the wild. The country’s been trying to reduce their population, and they’ve even…

Updated First Responder Kit and Consultant Toolkit for July 2021

Last Updated July 25, 2021

I’m slowing the First Responder Kit update frequency down to once every 2 months. I know from firsthand experience working with clients that folks just can’t patch quickly enough, hahaha. Folks who want to be on the bleeding edge updates can always use the dev branch in Github, too, getting every new fix the moment…

Stop Procrastinating: Master Index Tuning in 1 Month for $195.

Last Updated July 10, 2021

Indexing

You’ve conquered my Fundamentals of Index Tuning and Fundamentals of Columnstore classes, and you’re ready to take it to the next level. It’s time for you to join my Mastering Index Tuning class. When I teach it live – the next one is July 19-21 – it’s 3 days of lectures and hands-on labs where you learn: How to…

Updated First Responder Kit and Consultant Toolkit for June 2021

Last Updated June 1, 2021

If you want to quickly understand the top health and performance issues on your SQL Server, there’s no better, easier, free-er way to do it than the open source First Responder Kit. When you find a bug or want something changed, read the contributing.md file. Wanna watch me use it? Take the class. To get…

Free Video: Deadlocks: Let’s Do One, Understand It, and Fix It

Last Updated May 10, 2021

Deadlocks, Videos

You keep getting warnings and emails about deadlocks, but let’s be honest: you’re not really sure how they happen or what to do about it. In this one-hour session from the SQLBits conference, I will show one, use sp_BlitzLock to analyze it, then fix it. If you like this video, check out the SQLBits YouTube…

Updated First Responder Kit and Consultant Toolkit for April 2021

Last Updated April 20, 2021

This month’s release has two gems for SQL Server 2019 users. First, thanks to Greg Dodd, when you’re dealing with parameter sniffing issues, sp_BlitzWho can now show you the cached and live parameters for running queries. This lets you quickly see when the parameters may be wildly different, leading to issues like incorrect memory grants…

Azure SQL DB Frequently Asked Questions

Last Updated April 14, 2021

Azure SQL DB

I’ve seen your search history. Let’s get you some answers. Is Azure SQL DB PaaS, IaaS, or SaaS? Azure SQL DB is platform-as-a-service (PaaS). Microsoft manages most common database tasks for you, and they act as your DBA. This also means that like a DBA, Microsoft will tell you “no” if you try to implement…

How My Attitude and Branding Changed Over 20 Years

Last Updated March 30, 2021

Professional Development

This month, to mark the 20th anniversary of BrentOzar.com, I’m stepping back and looking at the big picture rather than blogging about database problems & solutions like I usually do. It wouldn’t be a good navel-gazing series without a couple thousands words looking inward at myself. When I first got started writing online, I was…

The Way Developers and Users Interact is Broken.

Last Updated March 24, 2021

Azure Data Studio, SQL Server Management Studio

This month, to mark the 20th anniversary of BrentOzar.com, I’m stepping back and looking at the big picture rather than blogging about database problems & solutions like I usually do. Twenty years ago, I tried to switch to Linux. Again. That wasn’t my first attempt, nor was it my last – there were so many…

Updated First Responder Kit and Consultant Toolkit for March 2021

Last Updated March 22, 2021

Brad McGehee speaking to the Red Gate PASS party, 2011 Ten years ago, I unveiled sp_Blitz at the 2011 PASS Summit, in front of a live audience. Remember the PASS Summit? Remember live audiences? <sigh> Anyway, to celebrate the 20th anniversary of BrentOzar.com, I’ve thinking back about the last couple of decades to reminisce about what I’ve…

Updated First Responder Kit and Consultant Toolkit for February 2021

Last Updated February 22, 2021

Along with the usual bug fixes & improvements, this month’s release includes a brand new sp_BlitzAnalysis script from Adrian Buckman. It’s for folks who have an Agent job to log sp_BlitzFirst to tables every 15 minutes, saving wait stats, Perfmon counters, file stats, etc into tables. sp_BlitzAnalysis reads those tables and sums up activity in…

Updated First Responder Kit and Consultant Toolkit for January 2021

Last Updated January 21, 2021