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

Welcome to sp_BlitzCache™ v2.4. This release brings a few changes and bug fixes. Fixed a logical error in detecting the output table. Thanks to Michael Bluett for pointing that out. Sorting by executions per second finally works. Thanks to Andrew Notarian and Calvin Jones for submitting this week. Added a @query_filter parameter – this allows…

Announcing sp_Blitz v36: New Database Checks, Hekaton, Azure Files, More

Last Updated February 13, 2017

In-Memory OLTP (Hekaton), SQL Server

The latest version of our free SQL Server health check adds some nifty new stuff: Checks for non-default database configurations like enabling forced parameterization or delayed durability Looks in the default trace for long file growths or serious errors like memory dumps Checks Hekaton memory use and transaction errors Warns about database files on network…

New sp_Blitz® v35 Checks for Unsupported and Dangerous SQL Server Builds

Last Updated February 13, 2017

First Responder Kit, SQL Server

News broke recently of a dangerous data loss bug in SQL Server 2012 and 2014, and Aaron Bertrand explained which patch levels are affected. It’s kinda tricky, and I’m afraid most people aren’t even going to know about the bug – let alone whether or not they’re on a bad version. I added build number checking into…

Introducing sp_BlitzCache®

Last Updated April 1, 2020

Jeremiah Peschka

First Responder Kit, SQL Server

Finding the worst queries in SQL Server is easy, right? You just query one of the dm_exec_* DMVs, bring in the SQL text and the execution plan, and then you spend hours looking at execution plans trying to figure out what’s wrong in the query, much less how to fix it. All that’s changing – we’re introducing sp_BlitzCache®.…

sp_BlitzCache®: Free SQL Server Plan Cache Analysis Script

Last Updated February 22, 2021

Jeremiah Peschka

sp_BlitzCache®: Find Your Worst-Performing Queries You have a SQL Server and you’re not sure which queries are causing your biggest performance problems. You don’t know where to start or if there are hidden queries that are making your main queries slower. You want a fast tool to find the worst queries in the SQL Server…

sp_BlitzIndex Workaholic Indexes

Last Updated January 30, 2014

Workaholic Indexes These poor indexes. Do they ever get to rest? Checking for top tables We have two checks for workaholics. In sp_BlitzIndex® output, they’ll look something like this: Click to view in a larger window Let’s break down what that means. Workaholics: Scan-a-lots (sys.dm_db_index_usage_stats) These indexes show as having the top user scans according…

sp_Blitz® v32: Emailing, Serializable Locking, Simultaneous Agent Jobs, and More

Last Updated January 20, 2014

The latest version of our SQL Server health check stored procedure is out today. Here’s what we’ve added in the last couple of versions – big thanks to the folks who keep making this even better for the community: Changes in v33 – January 20, 2014: Bob Klimes fixed a bug that Russell Hart introduced…

Announcing sp_BlitzFirst® for Troubleshooting Slow SQL Servers

Last Updated March 26, 2014

When someone tells you the SQL Server is slow, what do you do? Run sp_who looking for queries that might be blocking someone Check the SQL Agent jobs to see if there’s a backup job running Fire up Activity Monitor looking for problems Remote desktop into the server to look at CPU use Open Perfmon…

Celebrating Two Years of sp_Blitz® (And a New Version)

Last Updated February 13, 2017

#SQLPass, First Responder Kit, SQL Server

Two years ago this week, I took to the stage at the PASS Summit 2011 and unveiled sp_Blitz®, my free health check stored procedure that helps you rapidly take over SQL Servers you’ve never seen before. Some historical highlights include: 117,125 downloads 117 checks (technically much more than that, because we look for variations of…

sp_BlitzFirst

Last Updated May 8, 2021

sp_BlitzFirst Helps You Troubleshoot Slow SQL Servers. I kept getting emails and phone calls that said, “The SQL Server is running slow right now, and they told me to ask Brent.” Each time, I’d have to: Look at sp_who or sp_who2 or sp_WhoIsActive for blocking or long-running queries Review the SQL Server Agent jobs to…

sp_Blitz® v22: Output Results to a Table, Better Comments, and an App

Last Updated June 7, 2015

Our free server troubleshooting tool, sp_Blitz®, just learned some new tricks. If you call it like this: EXEC dbo.sp_Blitz @OutputDatabaseName = ‘DBAtools’, @OutputSchemaName = ‘dbo’, @OutputTableName = ‘BlitzResults’ It will create the table DBAtools.dbo.BlitzResults (if it doesn’t already exist) and insert the results. The table includes columns for the server name and the check date,…

sp_Blitz® Documentation

Last Updated April 9, 2015

sp_Blitz® Documentation Please don’t use your SQL Server as a print queue for sp_Blitz® documentation. sp_Blitz® is a free SQL Server health check stored procedure that looks for a lot of common health and performance issues. If you just use the default parameters, you’ll get a prioritized list of problems, but by tweaking the input…

sp_Blitz® Version 18 Out: Lots of Bug Fixes

Last Updated March 26, 2014

There’s a new version in town. v18 adds new checks looking for: Backups stored on the same drive letters as user databases (Thanks @AlinSelicean!) Agent jobs that don’t have failure notifications set up (Thanks @Thirster42!) Shows free drive space per drive letter if you pass @CheckServerInfo = 1 in. We don’t consider this a problem…

sp_BlitzIndex® Holiday Week Edition

Last Updated February 13, 2017

First Responder Kit, SQL Server

Only one thing could have dragged me away from the soft glow of the electric leg lamp glowing in the window… sp_BlitzIndex® It’s one of those weeks when things get nice and slow. Your business users and managers are all out of the office due to holidays. Your inbox is blissfully quiet. You get a…

sp_BlitzIndex Abnormal Psych

Last Updated July 2, 2018

sp_BlitzIndex® says: We’re Not in Kansas Anymore Our sp_BlitzIndex® script checks out your indexes and lets you know when it finds some things that are unusual. Abnormal psychology findings aren’t necessarily problems– just look at this as a big FYI. Some implementations of indexes may mean that the database can only be restored in a certain…

Instant Index Insight: How to Use sp_BlitzIndex® (video)

Last Updated February 13, 2017

First Responder Kit, Videos

You probably don’t have enough time to dig through DMVs trying to figure out which indexes you should add or drop. Whether you’re a DBA or developer, junior or senior, you’re probably too busy doing your real job to master all the index best practices – and now you don’t have to. In this 30…

I'll give you fifteen minutes to stop that.

sp_Blitz® v16: Snapshots, Recompiles, ShrinkDB, and More

Last Updated March 26, 2014

I don’t blog every release of sp_Blitz® (we pushed v15 out silently with a few bug fixes) but we added a lot of improvements and fixes in this version – and by we I mean you. After I blogged about v14’s release earlier this week, that encouraged a lot of people to come out of the woodwork…

sp_Blitz® v14 Adds VLFs, DBCC, Failsafe Operators, and More

Last Updated March 26, 2014

Today, we’ve got a big one, and it’s all thanks to you. For the last couple of versions, I haven’t added any big features because I’d been focused on the plan cache improvements. Today, though, we’ve got a big one with all kinds of health-checking improvements – and they’re all thanks to your contributions. Lori…

Introducing the SQL Server Plan Cache (and a Better sp_Blitz®)

Last Updated February 13, 2017