Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

0
votes
1answer
29 views

First Responder Kit Power BI Dashboard - New Databases

With the PowerBi and sp_blitz scripts running in a scheduled task I can get the great dashboard and reports. However when I add a new database to the server they don't show up in the reports later ...
0
votes
0answers
12 views

Transaction Replication from multiple servers is truncating the destination table

I am trying to centralise the results of sp_Blitz from multiple servers into one centralised server using table level transaction replication. At the moment I am just testing this to make sure it ...
3
votes
1answer
133 views

Minutely Log Backups - Missed Jobs

I tried searching for this but couldn't find an existing question about this. I'm considering implementing Brent Ozar's suggestion to backup minutely for our critical databases. I don't have a great ...
2
votes
2answers
530 views

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 ...
0
votes
1answer
119 views

User created index question - sp_Blitz 5/17/18 - Incorrect output?

I have SQL Server 2014 CU11 with sp_Blitz 5/17/18 8:44AM release. sp_Blitz is reporting that I have user created statistics on some of my databases. I've executed a script that deletes all user ...
5
votes
1answer
66 views

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. ...
0
votes
0answers
32 views

sp_blitz returns problems with master db

I recently setup a new SQL standard 2016 server (not in production yet). I just ran sp_blitz and have two records under priority 50 - Reliability "Errors Logged Recently in the Default Trace" for the ...
0
votes
1answer
74 views

sp_Blitz taking too long to complete

I just installed sp_Blitz and it has been running for an hour and still won't complete. I am able to run sp_BlitzFirst and it takes about 3 minutes to run but does complete. Any idea why it won't ...
0
votes
0answers
32 views

Why does sp_Blitz give error locating log_XX.trc file when using @CheckServerInfo = 1?

I'm running sp_Blitz from Feb 1, 2018 on a server running: Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on ...
0
votes
1answer
180 views

SQL Server sp_BlitzCache - Many Plans for One Query

I'm in need of a bit of assistance. I ran sp_Blitz on one of my SQL Servers and one of the results it returned is "1531 plans are present for a single query in the plan cache - meaning we probably ...
1
vote
2answers
94 views

How do I check my sp_Blitz/sp_WhoIsActive versions across multiple servers/databases?

I have a bunch of SQL Servers registered within my SSMS, lots of different SQL versions, editions and DB compatibilities. I want to check out if any of those servers have any of the sp_Blitz or ...
3
votes
2answers
294 views

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 ...
-1
votes
1answer
96 views

sp_blitz shows “Last good DBCC CHECKDB over 2 weeks old”

When I run sp_blitz, I see -[ RECORD 5 ]------------------------- Priority | 1 FindingsGroup | Reliability Finding | Last good DBCC CHECKDB over 2 weeks old DatabaseName |...
-4
votes
1answer
121 views

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 ...
0
votes
1answer
138 views

FILESTREAM_WORKITEM_QUEUE high waits

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 FirstResponderKit.org, I'm seeing a VERY large range of ...
0
votes
0answers
353 views

TempDB Locking issue

Once per week i run the sp_blitz scripts from Brent Ozar to get a quick health check. At the last execution of the script i ran into something very strange. The query was blocked 45 minutes because of ...
1
vote
0answers
40 views

Full Text Catalog Indexes Not Populating

I ran sp_Blitz on a server and it indicated that full text indexes were not populating. I got a list of the indexes that are not populating and looked at the definitions of the indexes. The syntax ...
5
votes
1answer
470 views

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 ...
0
votes
1answer
41 views

sp_Blitz error: “File '' either does not exist..”

SQL Server 2008 v10.0.5538.0 sp_Blitz v5.5 I'm trying to run sp_Blitz for the first time and getting this error message: sp_Blitz @CheckUserDatabaseObjects = 0 Warning: Null value is eliminated ...
1
vote
0answers
33 views

sp_blitz reporting both msdb backup history not purged and purged too frequently

Just downloaded the last version of sp_blitz from github, and have run it on two different database servers. On both of them it reports both of the following findings: MSDB Backup History Not Purged ...
0
votes
0answers
35 views

SP_Blitz Parse errors

I have downloaded the latest First Responder Kit and was getting ready to run Install-All-Scripts.sql on my development instance which is 2012 enterprise ( 11.0.5058.0 (X64)). I brought it up in SSMS ...
2
votes
1answer
240 views

sp_Blitz - undocumented DBCC events related to the replication marked as a finding

Recently I found in the sp_Blitz output new finding 'Overall Events' in 'DBCC Events' findings group: 15278 DBCC events have taken place between Aug 8 2017 12:15AM and Aug 8 2017 8:17AM. This does ...
2
votes
1answer
298 views

How long does sp_blitz take to execute?

I'm trying to run sp_blitz on SQL Server 2014 and it seems to be taking a long time. What is the normal length? We only have around 30 databases. One is 300GB, but it's going on for 15 min.
0
votes
1answer
163 views

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 ...
0
votes
0answers
98 views

sp_BlitzFirst: Poison Wait - Why is this appearing?

When I execute sp_BlitzFirst I see a Poison Wait Detected: THREADPOOL entry. However, in the Detail column it says this: For 0 seconds over the last 60 seconds, SQL Server was waiting on this ...
0
votes
1answer
51 views

sp_Blitz does not warn “No Alerts for Corruption” if one of 3 is set

I was just setting up the Alert for Corruption. Error 823 Error 824 Error 825 Before setup: I just by chance added alert for Error 825 and ran sp_Blitz again. And the message for Finding "No Alert ...
2
votes
1answer
250 views

Fix RESOURCE_SEMAPHORE

I ran sp_Blitz and on the top I got: Finding: Poison Wait Detected: RESOURCE_SEMAPHORE Details: 0:12:36:38 of this wait have been recorded. This wait often indicates killer performance ...
3
votes
1answer
69 views

sp_Blitz Findings: SQL Server Last Restart is an hour before Server Last Restart

Result of sp_Blitz: Finding = “Server Last Restart” ; Details = “Feb 11 2017 5:48AM” Finding = “SQL Server Last Restart” ; Details = “Feb 11 2017 4:48AM” SQL Server Last Restart is the tempdb ...
0
votes
1answer
89 views

Statements currently running in sp_blitzFirst

I am using the SQL Server First Responder Kit and was wondering if sp_blitzFirst no longer shows the current running queries? It used to show these both at the start and at the end of the run if @...
3
votes
1answer
1k views

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 ...
1
vote
2answers
115 views

easy upgrade of all sp_blitz-procs?

I wonder if you could make the upgrade of the procs easier and faster by providing a sqlcmd-skript or something which executes all sp_blitz[xxx].sql files. I first did a little sqlcmd-script myself (...
3
votes
1answer
366 views

sp_Blitz: Poison wait detected and too much free memory

We have a website for SolarWinds Orion which utilizes SQL and we've had many reports of slowness issues with the website. I ran sp_Blitz on the SQL box and I'm seeing these errors: Poison Wait ...
2
votes
0answers
413 views

sp_BlitzCache: Plan Cache 100% in last 4 hours

This is a re-post of my question here BlitzCache suggests there may be memory pressure, but I think there is another problem. I just don't know what that problem is! sp_blitzFirst @ExpertMode = 1; ...
1
vote
0answers
73 views

Why does sp_Blitz not show anything in the result set? [closed]

I've recently downloaded and tested the nice sp_Blitz script in an SQL Server 2008 R2 just to have a glance at what it actually does. To my surprise, the script ran without errors, but nothing shows ...
0
votes
2answers
318 views

Arithmetic overflow error when using sp_Blitz

I am getting this error: Msg 8115, Level 16, State 2, Procedure sp_Blitz, Line 469 Arithmetic overflow error converting expression to data type int. when running sp_Blitz in a server with 52 ...
0
votes
1answer
44 views

Does Page verification require downtime?

So I used sp_blitz and came across a suggestion to change verification to checksum. What I want to know is, would this step require any downtime?
1
vote
1answer
155 views

sp_BlitzFirst @AsOf Functionality Not Working?

I'm trying to run the sp_BlitzFirst stored procedure (using the 7/15/2016 version) with the @AsOf parameter, and I'm getting this error: EXEC sp_BlitzFirst @AsOf = '2015-02-23 18:45', @...
2
votes
1answer
83 views

sp_Blitz “Too Much Free Memory” on seldom-used SSRS instance

sp_Blitz (20160715) is reporting "Too Much Free Memory" on a seldom-used 2012 SP2 CU12 test instance (Developer Edition) that only contains the databases created and used by SSRS. The Details are: ...
0
votes
1answer
109 views

Blitz procedure failing [duplicate]

When I run the latest version of sp_blitz I get the following: Warning: Null value is eliminated by an aggregate or other SET operation. Msg 1934, Level 16, State 1, Procedure sp_Blitz, Line 3467 ...
7
votes
2answers
568 views

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 ...
8
votes
2answers
2k views

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 ...
5
votes
1answer
441 views

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 ...
1
vote
1answer
60 views

Is there an actual problem in my storage IO or is the data incorrect?

Running SP_Blitz indicated that I have a slow read/write performance on my drives. Reading further, I eventually landed on this query to view the actual statistics of IO occurring on my drives: ...
4
votes
1answer
1k views

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 ...
1
vote
1answer
183 views

Auto update stats turned off for a user database on SQL Server

While trying to improve the performance of few queries, we found via execution plan that there were lot of index / clustered index seeks. Therefore: First thing we did, was to check our Re-indexing ...
8
votes
1answer
2k views

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, ...