Skip to main content

Questions tagged [sp-blitz]

sp_Blitz is a stored procedure that checks the health of your Microsoft SQL Server instance.

Filter by
Sorted by
Tagged with
-4 votes
1 answer

Getting errors when installing and using sp_blitz with `sqlcmd.exe`?

I installed this third party thingy, sp_Blitz. sqlcmd -S localhost -U sa -i ./sp_Blitz.sql But when I run 1> EXEC sp_blitz; 2> go I get, Warning: Null value is eliminated by an aggregate ...
Evan Carroll's user avatar
  • 63.7k
5 votes
1 answer

sp_Blitz says "Page Verification Not Optimal" on MDS database

I've run sp_blitz (version 45) on our test database server. It complains about Database [MDS] has TORN_PAGE_DETECTION for page verification. SQL Server may have a harder time recognizing and ...
Henrik Staun Poulsen's user avatar
4 votes
2 answers

sp_Blitz, >1000 plans for CREATE PROCEDURE

I'm using Brent Ozar's sp_Blitz, and one of its results is this: Many Plans for One Query 1146 plans are present for a single query in the plan cache - meaning we probably have parameterization ...
Christian Specht's user avatar
3 votes
3 answers

Use sp_Blitz to gather information on all servers in a centralized server/database

I am using sp_Blitz, and want to use it to execute the checks on all of my SQL Servers and have it write the results to a single table. Do I need to create linked servers on the central instance to ...
SQL_Hacker's user avatar
40 votes
3 answers

SQL Server's "Total Server Memory" consumption stagnant for months with 64GB+ more available

I have run into an odd issue where SQL Server 2016 Standard Edition 64-bit has seemed to have capped itself off at precisely half of the total memory allocated towards it (64GB of 128GB). The output ...
PicoDeGallo's user avatar
  • 1,564
5 votes
1 answer

install FirstResponderKit in Azure SQL DB?

I've just downloaded the newest version (20190128) of FirstResponderKit from, and tried to install it on Azure SQL DB. I'm getting these errors: Msg 40515, Level 15, State 1, Procedure ...
Henrik Staun Poulsen's user avatar
3 votes
1 answer

NUMA config - sp_blitz output

I'm trying to learn more about how SQL Server works with NUMA nodes as I noticed something in the output of sp_Blitz that I didn't understand: Node: 0 State: ONLINE Online schedulers: 8 Offline ...
FrugalShaun's user avatar
3 votes
2 answers

Database file ..._log has a max file size set to x MB. If it runs out of space, the database will stop working

I am using BrentOzar's SQL Server First Responder Kit since I fall under the category "developer who manages Microsoft SQL Servers. It's your fault if they're down or slow." One of the warning of ...
Alexei's user avatar
  • 1,271
1 vote
1 answer


I've been using sp_BlitzFirst and logging the results every 15 minutes for the past 5 days. Using the new Power BI report from, I'm seeing a VERY large range of ...
Ulfius's user avatar
  • 133
0 votes
1 answer

sp_BlitzFirst - Wait Stats Interpretation

I have some BlitzFirst Wait Stats that look as follows: Is this the proper way to interpret this? During the 30 second sample, there were a total of 627.1 seconds of IO_Completion waiting, an average ...
Randy Minder's user avatar
  • 2,002