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

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_BlitzCache to Find Slow Queries How to Use…

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

Last Updated February 13, 2017

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

Last Updated August 29, 2020

Execution Plans, Parameter Sniffing, 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

Last Updated January 8, 2019

Erik Darling

First Responder Kit, Memory Grants, sp_BlitzCache, sp_BlitzFirst

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…

sp_BlitzFirst @SinceStartup = 1 Shows You Wait Stats Since, Uh, Startup

Last Updated February 13, 2017

SQL Server, Wait Stats

It’s this easy to get a cumulative recap of wait stats, file stats, and Perfmon counters: sp_BlitzFirst @SinceStartup = 1 In the above example, here’s what the wait stats columns mean: Sample Ended – when it ran Hours Sample – the number of hours your SQL Server instance has been up wait_type – the name of…

First Responder Kit Updated, and sp_AskBrent is now sp_BlitzFirst

Last Updated October 5, 2020

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…

We’re Renaming sp_BlitzFirst. What Should the New Name Be?

Last Updated April 9, 2017

338

Yesterday we announced that we’re open sourcing our free SQL Server scripts, and one of those is sp_BlitzFirst. I originally named it that because it had a funny magic-8-ball type feature: if you pass in a question as a parameter, it gives you an answer like “Outlook not so good, Access even worse.” Cute, but now…

We’re open-sourcing the sp_Blitz* scripts.

Last Updated June 20, 2016

We’re proud to announce that our First Responder Kit is now on Github, and it now uses the MIT open source license. What This Means for Users Good news: it’s still free, and now it’ll be updated even more often. If you’re subscribed to update notifications, we’ll still email you monthly when we release new versions. Today, we’re…

sp_Blitz v51: @IgnorePrioritiesAbove = 50 gets you a daily briefing

Last Updated November 16, 2017

sp_Blitz

You have a monitoring tool, but you’ve set up an email rule to dump all the alerts into a folder. You’re not particularly proud of that, but it is what it is. You’re just tired of the spam. Group query in the registered servers list But when you get in in the morning, you want…

Announcing sp_BlitzIndex® v3.0, sp_Blitz® v48, More

Last Updated February 13, 2017

Lots of fun stuff out this week: sp_BlitzIndex® v3.0 adds prioritized, streamlined results. We see so many index design disasters, and we know you have a limited amount of time. Doug Lane put a ton of work into focusing the output on the most important issues, things that are easy-to-fix and will have an immediate performance improvement, and…

sp_BlitzCache ChangeLog

Last Updated March 15, 2016

I feel pretty! sp_BlitzCache® Change Log Interested in the exciting back-story of our free sp_BlitzCache®? Here’s the play-by-play history: What’s New in v2.5.1 – 2016-03-15 Nick Molyneux fixed an overflow error, and did an amazing job of it. What’s New in v2.5.0 – 2015-10-23 Now with errors when required values are set to NULL. Thanks to Raul…

It’s Now Easier to Query sp_BlitzFirst’s Historical Tables

Last Updated January 7, 2016

When you want to know why the server’s slow, you can ask Brent. sp_BlitzFirst® checks a lot of DMVs to find common causes of server slowness. When you turn on @ExpertMode = 1, you can see additional information like file stats, wait stats, and Perfmon counters. To log those to a table permanently, check out…

sp_Blitz® v44: Reorganized and Reprioritized Results.

Last Updated January 7, 2016

Angie Walker, our new Triage Specialist, had the fun experience of sitting in and watching several of our SQL Critical Care® engagements. When I asked her if she noticed any patterns or ways we could improve, she said, “The order of sp_Blitz’s output needs to be reworked for 2016. There’s some stuff at the top that isn’t really high-priority…

Announcing sp_BlitzCache v2.5.0

Last Updated October 22, 2015

Jeremiah Peschka

Woohoo, it’s another half of the year which means it’s time for another version of sp_BlitzCache®. The last version came out on June 18th, and it’s been about 4 months. In that time frame, you have requested some new features, and they’ve slowly trickled into sp_BlitzCache®. If you don’t want to wait, head over to the download…

New Updates for sp_Blitz®, sp_BlitzCache™

Last Updated June 19, 2015

We’ve just updated our First Responder Kit to include new versions of these tools: sp_Blitz® v41 – June 18, 2015: Added check 162 for CMEMTHREAD waits on servers with >= 8 logical processors per NUMA node. Added check 159 for NUMA nodes reporting dangerously low memory in sys.dm_os_nodes. Added check 161 for a high number of cached…

New sp_BlitzFirst® Reports on Waits, Files, Perfmon Since Startup

Last Updated June 11, 2015

When your SQL Server is slow right now, you can run sp_BlitzFirst® to find out what’s going on. It checks for things like long-running queries, backups, blocking, files growing, and will tell you the top wait stats right now. You can use the @Seconds parameter to control the sample length – by default, it samples…

New sp_Blitz® and sp_BlitzCache® Updates

Last Updated April 30, 2015

Ah, spring, when a young man’s fancy lightly turns to thoughts of updating his DMV queries. sp_Blitz®, our free health check stored procedure, brings several new checks and a whole crop of fixes and improvements. I’d like to call your attention to one in particular. Julie Citro fixed check 1, THE VERY FIRST CHECK IN THE…

sp_BlitzFirst v14 adds CPU % Utilization

Last Updated March 1, 2015