Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sp-blitz]

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

sp_Blitz is a free health check stored procedure for Microsoft SQL Server. It reviews your SQL Server's dynamic management views, error logs, and configurations, and gives you a prioritized list of things you want to be aware of before you work on that server.

It's designed for accidental database administrators - people who are responsible for the uptime and speed of their database servers, but don't have a lot of in-depth professional training for SQL Server. Each line has a URL you can copy/paste into your browser for more details about that warning. If you have a question about the warning, start with that URL first before asking questions here.

Tagging recommendation:

The sp-blitz tag is for support with the script. If you have a question about a particular SQL Server feature or error, and you happen to find it by using sp-blitz, you don't have to use this tag. (sp_Blitz surfaces all kinds of SQL Server nastiness.)

There are separate tags for sp_BlitzIndex, sp_BlitzCache, and the other free stored procs from the same company.

73 questions
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 of @@VERSION is: Microsoft SQL Server 2016…
PicoDeGallo
  • 1,554
  • 1
  • 20
  • 30
10
votes
2 answers

CPU Schedulers Offline

I logged onto a new clients systems and ran sp_blitz to see what's shaking. It reports back that "CPU Schedulers Offline" which is a new one for me. Some CPU cores are not accessible to SQL Server due to affinity masking or licensing…
billinkc
  • 16,143
  • 4
  • 54
  • 89
9
votes
1 answer

dbo.DTA_* tables in MSDB

I ran Brent Ozar's sp_blitz on one of my production server. IT tagged a few tables in the MSDB database as being user created. They all follow the pattern dbo.DTA_*. Do these table come with MSDB, or were they added by something/someone?
DForck42
  • 3,068
  • 3
  • 38
  • 67
9
votes
1 answer

CPU Usage Incorrect in sys.dm_os_ring_buffers

I'm running a cloud VPS with a SQL Server instance. Because it's for personal use, I'm using express edition (I can't use developer edition because I technically have production apps running on it and there's no way I could afford Standard+). I'm…
Josh Greenlaw
  • 93
  • 4
8
votes
2 answers

Brent Ozar First Responder Kit filter

About once a week the query sp_Blitz @IgnorePrioritiesAbove = 50, @CheckUserDatabaseObjects = 0 shows "errors" with DB backups that are very old. It's correct to show this, but is it possible to filter this error in case of availability group…
Grégoire Titzé
  • 81
  • 2
7
votes
1 answer

Minimum permissions required to run sp_Blitz

I need to run sp_Blitz and a bunch of DMV queries from Glenn Berry's Dr DMV set for SQL 2016. The documentation for sp_Blitz on BrentOzar.com states "Sysadmin permissions. sp_Blitz® checks a lot of system-level diagnostic data." Is sysadmin really…
SQLBadPanda
  • 181
  • 7
6
votes
2 answers

Can a server wide setting of 'Max Degree of Parallelism' = 1 cause Brent Ozar's sp_BlitzCache to flag execution plan as 'forced-serialization'?

I am using Brent Ozar's sp_BlitzCache store procedure and I'm attempting to nail down why it is reporting: "Something in your plan is forcing a serial query. Further investigation is needed if this is not by design." Upon investigation I found…
D-K
  • 543
  • 1
  • 5
  • 17
6
votes
1 answer

install FirstResponderKit in Azure SQL DB?

I've just downloaded the newest version (20190128) of FirstResponderKit from BrentOzar.com, and tried to install it on Azure SQL DB. I'm getting these errors: Msg 40515, Level 15, State 1, Procedure sp_AllNightLog, Line 16 [Batch Start Line…
Henrik Staun Poulsen
  • 2,249
  • 2
  • 23
  • 41
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 recovering from storage corruption. Consider using…
Henrik Staun Poulsen
  • 2,249
  • 2
  • 23
  • 41
4
votes
2 answers

sp_Blitz fails with collation error

SQL Server version (output from select @@VERSION): Microsoft SQL Server 2017 (RTM-CU19) (KB4535007) - 14.0.3281.6 (X64) (Build 14393: ) Installed sp_Blitz from Brent Ozar, stored procedure creates successfully. Version info from the code: SELECT…
SJWales
  • 109
  • 2
  • 10
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 issues. The link in the result has this query: SELECT…
Christian Specht
  • 355
  • 5
  • 13
4
votes
1 answer

Resolving sp_Blitz Finding: Many Plans for One Query

Why Multiple Plans for One Query Are Bad So I was running sp_Blitz to get a handle on some systems. Got some code to get cleaned up as usual. Some heaps that should have been clustered indexes. etc. This particular query was using literals,…
Cade Roux
  • 6,684
  • 1
  • 33
  • 55
4
votes
1 answer

Do I have a memory issue?

I ran sp_Blitz that pointed me to a memory issue saying: Memory Dangerously Low The server has 32755 megabytes of physical memory, but only 235 megabytes are available. As the server runs out of memory, there is danger of swapping to disk,…
Magier
  • 4,827
  • 8
  • 48
  • 91
3
votes
1 answer

sp_blitzlock returns blank data in SQL Managed instance

I have a SQL Managed Instance in Azure with some blocking/deadlocking going on. This DB was on-premise and had all the scripts installed, so I uninstalled them and then installed the Azure specific scripts (Install-Azure.sql), downloaded fresh from…
Aaron Giambattista
  • 33
  • 2
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 schedulers: 0 Processor Group: 0 Memory node: 0 Memory…
FrugalShaun
  • 441
  • 3
  • 11
1
2 3 4 5