First Responder Kit Archives - Page 3 of 4

Crappy Missing Index Requests

February 21, 2017

Execution Plans, Indexing, sp_BlitzIndex

dba, development, performance tuning, sql server

When you’re tuning queries It’s sort of a relief when the first time you get your hands on it, you get the plan and there’s a missing index request. Even if it’s not a super high-value one, something in there is crying for help. Where there’s smoke, there’s a bingo parlor. But does adding missing…

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

February 9, 2017

Brent Ozar

First Responder Kit, sp_Blitz

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…

First Responder Kit Updates: So Many Updates, Brent Quit

January 27, 2017

Erik Darling

First Responder Kit, SQL Server

dba, development, sp_blitz, sp_BlitzCache, sp_BlitzFirst, sp_blitzindex

I got 128 GB of RAM just to develop sp_BlitzCache with! Also, thanks to @RichBenner @BrentOzar and @douglane for code, and @LitKnd and @HenrikStaunPoulsen for great ideas! Grab the newly updated First Responder Kit, and here’s what’s in it: sp_Blitz Improvements #677 Finally! A bug that isn’t ours! Microsoft forget to let SE clean up…

Analyzing Temporary Stored Procedures with sp_BlitzCache

January 24, 2017

Erik Darling

First Responder Kit, sp_BlitzCache, TempDB

dba, development, performance tuning, sql server

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

December 14, 2016

Erik Darling

Execution Plans, First Responder Kit, SQL Server

dba, development, performance tuning, sp_BlitzCache, 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…

First Responder Kit Updates: New Checks Across the Board

December 13, 2016

Brent Ozar

First Responder Kit

It’s the December to Remember Script Event, and we’ve got updates to everything. Shout out to our contributors this month: @BlitzErik, @RichBenner, @runamuk0, @SQLMonger, and @BrentOzar. Grab the newly updated First Responder Kit, and here’s what’s in it: sp_Blitz Improvements #591 – add check for 2016 Standard installed without Service Pack 1 (coded by @RichBenner) #615…

Updated First Responder Kit: sp_Blitz, sp_BlitzCache, sp_BlitzIndex

November 15, 2016

Brent Ozar

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…

Silent Demo: The Plan Cache

October 31, 2016

Brent Ozar

Execution Plans, sp_BlitzCache, Videos

Shhh, and pay close attention. In 76 seconds, I’ll teach you something intriguing about the way SQL Server caches execution plans:

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

October 24, 2016

Brent Ozar

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

October 14, 2016

Brent Ozar

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…

What To Do If sp_BlitzFirst Warns About High Compilations

September 27, 2016

Erik Darling

First Responder Kit, sp_BlitzFirst, SQL Server

dba, development, performance tuning, sql server

Compiles Aren’t The Same As Recompiles If you’re seeing high RECOMPILES, this post isn’t for you. We’ll talk about the differences between compiles and recompiles, but not how to troubleshoot recompiles. Recompiles mean one of two obvious things: You have a RECOMPILE hint at the stored procedure or statement level, or SQL found a reason…

Learn to Use sp_Blitz, sp_BlitzCache, sp_BlitzFirst, and sp_BlitzIndex with These Tutorial Videos

September 12, 2016

Brent Ozar

First Responder Kit, sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex

There have been so many improvements lately to our First Responder Kit scripts that it was time to update our tutorial videos. Each of these is about ten minutes long and shows how to use ’em: How to Use sp_Blitz for a Health Check How to Use sp_BlitzFirst in a Performance Emergency How to Use…

First Responder Kit 2016-09: sp_Blitz, sp_BlitzCache, sp_BlitzIndex Improvements

September 3, 2016

Brent Ozar

First Responder Kit, SQL Server

No Comments

First, thanks to 5 community volunteers for contributing code this month. In addition to lots of bug fixes, small stuff, and a new Github issue template (thanks, Konstantin Taranov) here’s the big improvements: sp_Blitz Changes @OutputServerName writes output to remote server (Haris Khan) – for years, these stored procs have had an @OutputServerName parameter just waiting to…

Query Tuning Week: How to Run sp_BlitzCache on a Single Query

August 19, 2016

Brent Ozar

Execution Plans, sp_BlitzCache

The most popular way of using sp_BlitzCache® is to just run it – by default, it shows you the top 10 most CPU-intensive queries that have run on your server recently. Plus, it shows you warnings about each of the queries – if they’re missing indexes, experiencing parameter sniffing issues, running long, running frequently, doing…

Memory Grants Added to sp_BlitzCache and sp_BlitzFirst

August 8, 2016

Erik Darling

First Responder Kit, sp_BlitzCache, sp_BlitzFirst

dba, development, performance tuning, sql server

No Comments

Exciting New Doodads When SP3 for 2012 dropped, we were all super excited by the new query tuning-centric features that were at our disposal. Now all we had to do was get people to install SP3! Great features like this make patching an easier sell. Now with SP2 for 2014 out, a lot of those…

Where Do Missing Index Requests Come From?

July 27, 2016

Erik Darling

Indexing, sp_BlitzIndex

Be honest, here You don’t care about most indexing problems. Duplicates, Borderline Duplicates, Unused, Wide, Non-aligned Partitions… All you’re here for are the Missing Indexes. Wham, bam, your query finishes in less than a second, ma’am. Take this quarter, go downtown and have a rat gnaw that thing off your face. And I get it.…

How to Contribute Code to the SQL Server First Responder Kit (Github)

July 21, 2016

Brent Ozar

First Responder Kit, SQL Server

So you’d like to fix a bug or contribute code to the First Responder Kit, but you’re new to Github. Let’s get started. 1. Open a new issue on Github. Go to the Github issues list for this repo, and start a new issue. Here’s the example that I’m going to work on today: Example…

New SQL Server First Responder Kit for 2016-07

July 18, 2016

Brent Ozar

First Responder Kit, SQL Server

No Comments

SQL Server 2012 SP3, 2014 SP2, and 2016 users are going to find a lot of stuff to love in here. The new per-query memory grants fields in the plan cache are exposed in sp_BlitzCache, and sp_BlitzFirst also shows memory grants for live running queries in @ExpertMode = 1. Here’s the details: sp_BlitzCache v3.1: Show…

Breaking News: 2016 Query Store cleanup doesn’t work on Standard or Express Editions

July 4, 2016

Brent Ozar

Breaking News, First Responder Kit, Query Store (QDS), SQL Server

breaking news

If you’re using SQL Server 2016’s awesome new feature, Query Store, there’s a new bug with automatic cleanup. Books Online explains: Automatic data cleanup fails on editions other than Enterprise and Developer. Consequently, space used by the Query Store will grow over time until configured limit is reached, if data is not purged manually. If…

First Responder Kit Updated, and sp_BlitzFirst is now sp_BlitzFirst

June 28, 2016

Brent Ozar

First Responder Kit, SQL Server

We’ve released the first fully open source version of our SQL Server First Responder Kit: sp_Blitz, sp_BlitzCache, sp_BlitzIndex, sp_BlitzRS, sp_BlitzTrace, and the newest member: the newly renamed sp_BlitzFirst. I wanted to rename sp_BlitzFirst because as an open source project, it’s going to have more than just my own answers as to why your SQL Server…