Product has been added to your cart.

Search Results for “sp_blitz”

Home
Search Results

Pocket Square

sp_BlitzQueryStore: A Gentle Introduction

Last Updated May 26, 2020

Execution Plans, First Responder Kit, Parameter Sniffing, Query Store (QDS), sp_BlitzQueryStore, SQL Server 2016, SQL Server 2017

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.…

How to Track SQL Server Changes with sp_BlitzFirst

Last Updated November 22, 2017

First Responder Kit

In the First Responder Kit’s Power BI Dashboard, there’s a Quick Diagnosis results area where sp_BlitzFirst takes a guess at why your SQL Server was slow – or in this case, why it suddenly got faster: Logging your work in sp_BlitzFirst’s Quick Diagnosis results (click to zoom) In this case, wait times were bad, and…

sp_BlitzWho

Last Updated February 22, 2021

Brent Ozar Unlimited Team

Forget sp_Who and sp_Who2: sp_BlitzWho tells you what’s really happening. When you’re trying to troubleshoot a slow query, sp_who and sp_who2 don’t cut it. You need something that shows: Execution plans Memory grants Degrees of parallelism And a lot more useful stuff for query performance tuners That’s sp_BlitzWho. Download it in our free First Responder…

sp_BlitzQueryStore

Last Updated February 22, 2021

When I look at a SQL Server that’s in trouble, I wanna know what was going on when things were bad. When you run sp_BlitzQueryStore, it basically: Looks at your workloads over the last 7 days (that’s configurable) Finds the highest resource consuming periods of time Finds the top 3 queries that used the most…

How to Get Live Query Plans with sp_BlitzWho

Last Updated November 18, 2017

Execution Plans, First Responder Kit, sp_BlitzWho, SQL Server 2016

sp_BlitzWho is our open source replacement for sp_who and sp_who2. It has all kinds of really neat-o outputs like how many degrees of parallelism the query is using, how much memory it’s been granted, how long it’s been waiting for memory grants, and much more. If you’re on SQL Server 2016 SP1 or newer, it…

How to Log Wait Stats to Table with sp_BlitzFirst

Last Updated October 13, 2017

First Responder Kit, Wait Stats

When you’re analyzing SQL Server performance, one of the best places to start is wait stats. What’s your SQL Server waiting on? sp_BlitzFirst makes it really easy to trend this data over time for free with all currently supported versions of SQL Server (2008+). Just set up an Agent job to run this every 15 minutes:…

sp_BlitzCache: Eventual Compatibility With Azure

Last Updated November 16, 2017

Execution Plans, Microsoft Azure, sp_BlitzCache

Better than nothing Yesterday it was announced that global temp tables were available in public preview for Azure. That means that unmodified versions of sp_BlitzCache (which uses a global temp table to hold a whole bunch of information) will be compatible up there. This is a nice addition for Azure, and an even nicer addition…

Introducing sp_BlitzQueryStore

Last Updated November 16, 2017

Execution Plans, First Responder Kit, Query Store (QDS), sp_BlitzQueryStore

Oh, so you’re the one While SQL Server 2016 adoption is still pretty low, and 2017 still quite isn’t out yet, that’s no reason to not invest a few days of dev time into a stored procedure that is only usable by the smallest portion of SQL Server users. Right? Look, someone around here has…

Announcing sp_BlitzBackups: Check Yourself Before You Wreck Yourself.

Last Updated May 26, 2017

First Responder Kit

If one of your SQL Servers went down at some point over the last week: What’s the most data you could have lost? What’s the longest you would have been down for? To find out, Erik and I (mostly Erik) wrote sp_BlitzBackups (sure, blame me for everything. –ED). Download the latest First Responder Kit including the…

sp_BlitzCache Tip: Cutting Through Heavy Dynamic SQL Use

Last Updated November 16, 2017

First Responder Kit, sp_BlitzCache, T-SQL

It keeps me up at night Out of the box, sp_BlitzCache will give you enough stuff to work on in your server’s plan cache to last a month of leap days. This is great for most people, but if you use a ton of dynamic SQL in stored procedures, it can make things difficult. What’s…

A Tourist’s Guide to the sp_Blitz Source Code, Part 1: The Big Picture

Last Updated November 16, 2017

First Responder Kit, sp_Blitz

sp_Blitz is our open source free SQL Server health check script. From a really high level, here’s what it does: Create #BlitzResult, a temp table to hold its output Check something on your SQL Server, and if it’s found, insert a row into #BlitzResult Check something else, and insert a row if it’s found Do that…

3.1 How to Measure Your Server – Part 3: sp_BlitzFirst and Monitoring Software (24m)

Last Updated April 17, 2018

Brent Ozar Unlimited Team

We’ll explain how to get your 3 most important server metrics, demo a SQL Server under heavy load, and explain why monitoring software doesn’t really help the way you think it does. (Don’t get us wrong – we still love monitoring software – it’s just…)

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

1.5 Tuning Indexes with sp_BlitzIndex Part 2 (9m)

Last Updated April 17, 2018

Brent Ozar Unlimited Team

You’re not starting from scratch – you’re dealing with a database that already exists, and you have to make it go faster. You need to analyze the current indexes, remove the ones that aren’t helping, and add the right ones. We’ll show you how.

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

1.5 Tuning Indexes with sp_BlitzIndex Part 1 (47m)

Last Updated April 17, 2018

Brent Ozar Unlimited Team

You’re not starting from scratch – you’re dealing with a database that already exists, and you have to make it go faster. You need to analyze the current indexes, remove the ones that aren’t helping, and add the right ones. We’ll show you how.

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

02. Measuring Your SQL Server with sp_BlitzFirst and Monitoring Software (24 minutes)

Last Updated October 16, 2019

Brent Ozar Unlimited Team

We’ll explain how to get your 3 most important server metrics, demo a SQL Server under heavy load, and explain why monitoring software doesn’t really help the way you think it does. (Don’t get us wrong – we still love monitoring software – it’s just…)

To access this incredible, amazing content, you gotta get Fundamentals of Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.

Analyzing Temporary Stored Procedures with sp_BlitzCache

Last Updated November 16, 2017

First Responder Kit, sp_BlitzCache, TempDB

All the cool kids Know that when you’re trying to figure out why a stored procedure is slow sometimes, you should use a temporary stored procedure instead of pulling the code out and running it ad hoc. We frequently point people to Erland Sommarskog’s “Slow in the Application, Fast in SSMS“, because it’s an excellent…

Things I Would Love to Put In sp_BlitzCache

Last Updated April 21, 2017

Execution Plans, First Responder Kit, SQL Server

This is my favorite script to work on Getting stuff to work sp_BlitzCache is so rewarding because XML querying is so ridiculous. I wish Mikael Eriksson would write a book already; it’d make my life a whole lot easier. Along the way, I see a lot of things that I would love to warn people…

Pocket Square

Updated First Responder Kit: sp_Blitz, sp_BlitzCache, sp_BlitzIndex

Last Updated November 15, 2016

First Responder Kit, SQL Server

These improvements go great with cranberries. The food, not the b – actually, they go pretty well with the band, too. sp_Blitz Improvements #568 – @RichBenner added a check for the default parallelism settings sp_BlitzCache Improvements by @BlitzErik #495 – add warning for indexed views with missing stats #557 – bug fix – don’t alert…

First Responder Kit Update: sp_BlitzCache Catches Cursors, Scalar Functions, and More

Last Updated October 23, 2016

First Responder Kit

Every time we take on a client for our SQL Critical Care®, the very first thing we do is run the First Responder Kit scripts: sp_Blitz to get a health check, sp_BlitzFirst to check their wait stats, sp_BlitzIndex to look at their indexes, and sp_BlitzCache to see the most resource-intensive queries. Very often, these scripts surface…

Updated First Responder Kit: sp_Blitz markdown output, sp_BlitzIndex statistics checks

Last Updated April 25, 2017

First Responder Kit, SQL Server

In addition to lots of bug fixes and tweaks, my favorite option is: sp_Blitz @OutputType = ‘markdown’ sp_Blitz @OutputType = ‘markdown’, @CheckServerInfo = 1, @CheckUserDatabaseObjects = 1 See, recently I’ve spent a lot of time looking at Stack questions going, “Man, if I just had the output of sp_Blitz, I bet I could answer that question…