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

Objects created with dangerous SET Options in SSISDB

I recently updated my Brent Ozar first responder kit and ran sp_Blitz and it returned an alert: The [SSISDB] database has 107 objects that were created with dangerous ANSI_NULL or QUOTED_IDENTIFIER ...
Don's user avatar
  • 171
-1 votes
2 answers
193 views

Runing sp_Blitz on a database as a user - Work arounds please

I am a DBA on many servers running SQL Server and am a big user of sp_Blitz. The issue I have is that I am still to maintain a database that is migrating to a VM on AWS. The issue is that I'm not ...
user125942's user avatar
2 votes
1 answer
1k views

sp_blitz fails with: Msg 468, Level 16, State 9 Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_BIN"

Has anyone had an issue with running sp_blitz on an instance using the Latin1_BIN collation? I created the stored procedure without error, but when I ran it I got the following error message: Msg 468, ...
SQLSeeker's user avatar
-1 votes
1 answer
208 views

How to work around sp_blitzwho lock timeout?

Running sp_blitzwho @GetLiveQueryPlan = 1 on SQL2019 to monitor a big index rebuild operation but running into the following error: Lock request time out period exceeded. Anything I can do to avoid ...
user2368632's user avatar
  • 1,097
1 vote
1 answer
238 views

sp_BlitzFirst - SQL Server - slow data reads - huge wait stats

We are experiencing intermittent SQL Server issues, where from time to time, it would become unresponsive for a few minutes, causing an outage of a system, driving crazy many users. I started using ...
Agustin Garzon's user avatar
1 vote
1 answer
392 views

Does sp_Blitz @BringThePain parameter cause pain for the user (delay) or the server (blocking/slowing production workload)?

I want to run sp_Blitz and other scripts (from first aid) on a busy primary production server. There are 75 databases on the server, of which 40 are in an availability group (synchronous, no read ...
variable's user avatar
  • 3,568
0 votes
1 answer
132 views

sp_Blitz shows "write_conflict" from In-memory OLTP

My team came across a In-Memory OLTP (Hekaton) transaction issue with several of our machines showing that there were a varying number of write conflicts per machine. We do have Memory-Optimized ...
Evan King's user avatar
6 votes
2 answers
660 views

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 ...
D-K's user avatar
  • 513
1 vote
1 answer
348 views

Sp_BlitzWho can get blocked...?

I was playing around with sp_BlitzWho and got blocked by another session. The session was from the DB were sp_BlitzWho is... I was planning to automate it and save the results to a table, so I could ...
xhr489's user avatar
  • 807
3 votes
1 answer
237 views

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
1 answer
1k views

sp_blitz script not working on Azure sql database [closed]

sp_blitz script not working on Azure sql database Msg 40515, Level 15, State 1, Procedure sp_Blitz, Line 16 [Batch Start Line 3] Reference to database and/or server name in 'master.sys.all_objects' ...
Pankaj's user avatar
  • 1
1 vote
1 answer
45 views

How can sp_blitz help investigate what caused TLog to fill up

Non-uncommon scenario: Something has ran wild and caused the TLog for a patifular Db to fill and everything has stopped. How can sp_blitz show us some info on what led up to this point? What about ...
bitshift's user avatar
  • 113
0 votes
1 answer
435 views

Where can I find a list of CheckIDs for sp_Blitz?

We have a home-grown system of monitors and processes that generate events which are then gathered into a central instance and are sent as daily summary reports to operational DBAs via SSRS. It ...
Brettuss's user avatar
2 votes
2 answers
629 views

Permission denied when trying to install sp_blitz on in the master database in Amazon RDS

I am trying to install sp_blitz on AWS RDS SQL Server (14.0.3223.3) standard edition and getting following error: Msg 262, Level 14, State 18, Procedure sp_Blitz, Line 1 [Batch Start Line 0] CREATE ...
Fahd Mirza's user avatar
4 votes
2 answers
439 views

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 ...
SJWales's user avatar
  • 109
1 vote
2 answers
302 views

Error while running sp_blitz in 2008 SQL Server and lower versions

I have created an SSIS package to run sp_blitz in my production servers. The stored procedure runs fine for servers having a version higher than 2012 but fails for 2008 and 2005. Please find the ...
l.lijith's user avatar
  • 898
1 vote
0 answers
111 views

How to find DBCC events reported by sp_Blitz

sp_Blitz reports: Overall Events 7 DBCC events have taken place between Oct 14 2019 3:22PM and Nov 19 2019 12:24PM. This does not include CHECKDB and other usually benign DBCC events. How do I find ...
td48260's user avatar
  • 55
9 votes
1 answer
1k views

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 ...
Josh Greenlaw's user avatar
0 votes
1 answer
139 views

Exclude IP addresses of Vulnerability Scanner [closed]

I am working with the SQL team to see if there is a way to globally whitelist IP addresses that are causing alerts within sp_Blitz? Would like to have them exclude 5 IP addresses.
user192730's user avatar
0 votes
0 answers
119 views

SQL Performance post virtualization - sp_blitz and latency info attached

Full disclosure, I'm a VMware admin. We're trying to virtualize a SQL server that handles pricing information for multiple customers. Up until now, it has been a physical system with local SSDs. ...
Chrys Bundy's user avatar
1 vote
1 answer
325 views

sp_Blitz script output

I'm a very green DBA at my company, and ran the sp_Blitz script (on one of our test databases that is an exact copy of our production database), and I only get the message "Command(s) completed ...
apdlieske's user avatar
0 votes
1 answer
258 views

Why is sp_Blitz executing for more than 5 hours [closed]

Screenshot I am running sp_Blitz on my SQL Server 2014 with 93 databases. It has been running for more than 5 hours and still won't complete. I am able to run sp_BlitzWho,sp_BlitzIndex,sp_BlitzFirst ...
Alekhya's user avatar
1 vote
1 answer
1k views

sp_Blitz Error on Azure SQL Database [closed]

Getting the following error when trying to install sp_Blitz on a Azure SQL Database Msg 40515, Level 15, State 1, Procedure sp_Blitz, Line 16 [Batch Start Line 15] Reference to database and/or ...
Geezer's user avatar
  • 431
0 votes
1 answer
172 views

Who done it sp_blitz [closed]

is there a way to add Session ID and timestamp to your first responders scripts? In particular the sp_BlitzLock. I am trying to find out when and by who some adhoc scripts are run that cause blocking ...
Bryon Howe's user avatar
0 votes
1 answer
70 views

TSQL Agent jobs owned by users

I'm new to Brent Ozar's sp_blitz and am trying to do some cleanup in my new job. I get tons of security findings about agent jobs owned by users. Most of these hits are system-type accounts (...
Steve Pearson's user avatar
1 vote
1 answer
89 views

scheduler_count in Azure SQL DB

I'm trying to find a scheduler_count for my Azure SQL DB, so that I can get sp_Blitz to run. On all other platforms, scheduler_count can be read from sys.dm_os_sys_info, but this dmv is not available ...
Henrik Staun Poulsen's user avatar
0 votes
2 answers
644 views

Can sp_Blitz, sp_BlitzCache, or sp_BlitzFirst identify what queries caused a major growth operation to occur on a particular log file?

I'm currently logging the outputs of sp_Blitz, sp_BlitzCache, and sp_BlitzFirst regularly (via SQL jobs). A particular database's log file grew somewhat exponentially and I believe I can see the ...
J.D.'s user avatar
  • 38.1k
1 vote
0 answers
911 views

FOR XML could not serialize the data for node 'col_definition'

looking for some help. I have just started looking at the Blitz stats but getting the following error. This is whilst running sp_BlitzIndex. I am using Version 7.2 (dated 28/01/2019). FOR XML ...
MatthewM's user avatar
5 votes
1 answer
2k views

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 ...
Henrik Staun Poulsen's user avatar
1 vote
1 answer
411 views

Difference between request and session in sp_blitzwho?

I'm starting to use sp_blitzwho, and I was wondering about a few of the columns. There are a set of columns that start request_ such as request_writes, and then a set of columns that start session_, ...
BeginnerDBADan's user avatar
2 votes
0 answers
322 views

"Slow Storage Writes on Drive T" warning from sp_Blitz

We migrated our platform to new SQL Server 2016 instances a couple of nights ago. Immediately following the migration, we ran sp_Blitz again, but noticed the following entry, which relates to the ...
user3399498's user avatar
3 votes
1 answer
196 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 ...
JonDBA5420's user avatar
4 votes
2 answers
782 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 parameterization ...
Christian Specht's user avatar
0 votes
1 answer
136 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 ...
thatstevecena's user avatar
4 votes
1 answer
362 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. ...
Cade Roux's user avatar
  • 6,602
40 votes
3 answers
6k views

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
2 votes
2 answers
1k 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 ...
PBK's user avatar
  • 51
1 vote
1 answer
1k 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 ...
Sicilian-Najdorf's user avatar
3 votes
3 answers
897 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 ...
Oreo's user avatar
  • 1,528
3 votes
2 answers
603 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 ...
Alexei's user avatar
  • 1,271
-1 votes
1 answer
435 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 |...
Evan Carroll's user avatar
  • 63.7k
-4 votes
1 answer
329 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 ...
Evan Carroll's user avatar
  • 63.7k
1 vote
1 answer
515 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 ...
Ulfius's user avatar
  • 133
1 vote
0 answers
334 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 ...
Lee M's user avatar
  • 388
7 votes
1 answer
2k 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 ...
SQLBadPanda's user avatar
0 votes
1 answer
109 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 ...
Leonardo Salum's user avatar
1 vote
0 answers
113 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 ...
GHauan's user avatar
  • 603
2 votes
1 answer
653 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 ...
GrzegorzO's user avatar
  • 338
2 votes
1 answer
555 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.
Nathan's user avatar
  • 21
0 votes
1 answer
858 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 ...
Randy Minder's user avatar
  • 2,002