Search Results for “sp_blitz”

  1. Home
  2. Search Results
  3. (Page 3)

What To Do If sp_BlitzFirst Warns About High Compilations

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…
Read More

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

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…
Read More

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

First Responder Kit, SQL Server
0
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…
Read More

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

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…
Read More

First Responder Kit Updated, and sp_AskBrent is now sp_BlitzFirst

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…
Read More

We’re open-sourcing the sp_Blitz* scripts.

SQL Server
22 Comments
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…
Read More
Pocket Square

sp_BlitzCache ChangeLog

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…
Read More

sp_Blitz® v44: Reorganized and Reprioritized Results.

SQL Server
25 Comments
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…
Read More

Announcing sp_BlitzCache v2.5.0

SQL Server
14 Comments
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…
Read More

New Updates for sp_Blitz®, sp_BlitzCache™

SQL Server
24 Comments
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…
Read More

New sp_Blitz® and sp_BlitzCache® Updates

SQL Server
16 Comments
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…
Read More

sp_BlitzFirst v14 adds CPU % Utilization

SQL Server
1 Comment
When your SQL Server is having performance problems, sp_BlitzFirst® checks a bunch of common trouble spots. In this week’s new version, it also checks sys.dm_os_ring_buffers for the most recent CPU utilization report from SQL Server and returns it. Here’s what it looks like when the server isn’t under load – note that “No Problems Found” means…
Read More