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
0answers
915 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
46 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 ...
1
vote
0answers
326 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 ...
1
vote
0answers
160 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 ...
1
vote
0answers
269 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 ...
1
vote
0answers
75 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
1answer
46 views

sp_Blitz - RegOpenKeyEx() returned error 2

I'm running the latest sp_Blitz script on a SQL 2016 Std server on a Windows Server 2016 physical box. I'm getting the following error. What could be causing this and how do I troubleshoot it? ...
0
votes
0answers
77 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. ...
0
votes
0answers
149 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 ...