Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

Questions tagged [sp-blitz]

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

9 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
2 votes
0 answers
319 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
2 votes
0 answers
1k 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; ...
DaSiHu's user avatar
  • 39
1 vote
0 answers
109 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
1 vote
0 answers
895 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
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
1 vote
0 answers
112 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
0 votes
0 answers
52 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
  • 161
0 votes
0 answers
118 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