Search Results for “sp_blitz”

  1. Home
  2. Search Results
Pocket Square

Updated First Responder Kit for July 12, 2020: Fixing sp_BlitzFirst @ExpertMode

I don’t normally do multiple releases per month, but sp_BlitzFirst had a pretty big bug in the last release for those of us who do live performance tuning. In the July release, a well-meaning contributor tried to make sp_BlitzFirst faster when @OutputType = ‘NONE’, but inadvertently also made it faster when @ExpertMode = 1 – by…
Read More

[Video] Watch Brent Work on sp_Blitz

sp_Blitz, Videos
11 Comments
During the quarantines, I’m looking for new ways to help you level up for free. I decided to start live-streaming whenever I’m working on things I can share with you publicly. I wanted to add a new check to sp_Blitz, so I figured I’d do it live on camera while you watch, and talk you…
Read More

06 Check Which Queries Are Running with sp_BlitzWho and sp_WhoIsActive

When you wanna know which queries are running right now, sp_WhoIsActive is pretty much the world standard. However, there are some situations where you need to jump back in the past and troubleshoot complex issues like memory grants. I show how to use both sp_BlitzWho and sp_WhoIsActive for real time troubleshooting, plus set up an…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Recorded Class Season Pass or How I Use the First Responder Kit, or log in if you already shelled out the cash.
Read More

05 Analyzing Deadlocks with sp_BlitzLock

Deadlocks go bump in the night, and they’re kinda mysterious. Your monitoring app or developers might have been warning you about them, but nobody’s really sure what to do about ’em, or what code to look at. We’ll use sp_BlitzLock for analysis help to figure out what queries & tables need to be changed. In…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Recorded Class Season Pass or How I Use the First Responder Kit, or log in if you already shelled out the cash.
Read More

04 Using sp_BlitzIndex to Diagnose the Most Urgent Index Issues

Index tuning is the fastest way to make queries go faster without buying hardware or spending time in development. Indexing is as much an art as a science, though: there are a lot of vague guidelines, and sometimes you have to break those guidelines in order to get better performance. sp_BlitzIndex is about analyzing your…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Recorded Class Season Pass or How I Use the First Responder Kit, or log in if you already shelled out the cash.
Read More

03 Using sp_BlitzCache to Find the Queries Causing Your Top Waits

If I could only pick one script in the First Responder Kit to use for the rest of my life, it would probably be sp_BlitzCache. You could just run it as-is with no parameters and learn a lot, but it’s even better now that you’re armed with an understanding of your server’s top wait types….

To access this incredible, amazing content, you gotta get Live Class Season Pass, Recorded Class Season Pass or How I Use the First Responder Kit, or log in if you already shelled out the cash.
Read More

02 Doing a Server-Wide Performance Check with sp_BlitzFirst

I know, I know, the name sp_BlitzFirst sounds like it should be the first query that I would run – and it is, when I’m doing emergency performance troubleshooting. That’s not what we’re doing here, though. Here, we’re using it as part of a bigger process to check our server’s wait stats. I’ll talk about…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Recorded Class Season Pass or How I Use the First Responder Kit, or log in if you already shelled out the cash.
Read More

01 Doing a Server-Wide Health Check with sp_Blitz

When you’re first approaching a SQL Server, start with sp_Blitz. We’ll cover my favorite parameters and what I look for in the results, and then start building our notes in Markdown for our eventual health check recommendations for the rest of our team.

To access this incredible, amazing content, you gotta get Live Class Season Pass, Recorded Class Season Pass or How I Use the First Responder Kit, or log in if you already shelled out the cash.
Read More

4.3b Final Lab: Logging sp_BlitzCache to a Table

Oops! In the last module, while tuning a query, I accidentally cleared the plan cache with DBCC FREEPROCCACHE. Normally, that would be a huge problem for performance tuning – but thankfully, I’m logging sp_BlitzFirst and sp_BlitzCache to tables every 15 minutes in the lab. I show you how to jump back in time and grab…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Mastering Query Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.
Read More

How to Log Active Queries with sp_BlitzWho

Monitoring
4 Comments
Queries are running when you’re not around. They’re wreaking havoc – maybe they’re filling up your TempDB, or causing blocking, or flushing your buffer pool out. When I wanna see what queries are running, I run sp_BlitzWho: That shows me who’s running the query, what it’s been waiting on over time, memory grants, blocking, and…
Read More

How to Fix sp_BlitzIndex Aggressive Indexes Warnings

sp_BlitzIndex
11 Comments
sp_BlitzIndex gives your indexes a psychiatrist-style evaluation. It’s a lot like a real psychiatrist: it’s just flagging behaviors, and there’s not necessarily anything wrong with being a hoarder, or a workaholic, or a furry. They’re just behavioral traits. Let your freak flag fly. One of the warnings is “Aggressive Indexes,” which means sys.dm_db_operational_stats reports minutes of…
Read More

1.3 Indexes: How to Performance Tune Nonclustered Indexes with sp_BlitzIndex (70m)

What if you’re dealing with a database that already exists, and you need to make it go faster with the minimum changes possible? You need to analyze the current indexes, remove the ones that aren’t helping, and add the right ones. We’ll show you how. Part 1 (19 minutes): Part 2 (51m):

You’ll need a membership to access this course. Check out my training classes.
Read More
Pocket Square

sp_BlitzQueryStore: A Gentle Introduction

Odds and ends During the precon, we asked how many people were on 2016, how many people were aware of query store, how many people were using it, and how many people were using sp_BlitzQueryStore. About 1/3 of the hands went up at first, then for each successive question, fewer and fewer hands stayed up.…
Read More
Menu