Questions tagged [sp-blitz]
sp_Blitz is a stored procedure that checks the health of your Microsoft SQL Server instance.
70
questions
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 ...
- 1,564
10
votes
2
answers
4k
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 ...
- 16k
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 ...
9
votes
1
answer
4k
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, ...
- 3,058
8
votes
2
answers
732
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 ...
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 ...
- 181
6
votes
2
answers
669
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 ...
- 523
5
votes
1
answer
1k
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 ...
- 2,219
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 ...
- 2,219
4
votes
2
answers
789
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 ...
- 355
4
votes
2
answers
458
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 ...
- 109
4
votes
1
answer
2k
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 ...
- 4,797
4
votes
1
answer
378
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. ...
- 6,602
3
votes
2
answers
607
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,271
3
votes
3
answers
925
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 ...
- 1,540
3
votes
1
answer
146
views
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 ...
3
votes
1
answer
197
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 ...
- 97
3
votes
3
answers
5k
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 ...
- 501
3
votes
1
answer
1k
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 ...
- 31
3
votes
1
answer
244
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 ...
- 431
2
votes
2
answers
651
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 ...
- 21
2
votes
1
answer
558
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.
- 21
2
votes
1
answer
120
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:
...
- 2,191
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 ...
- 51
2
votes
1
answer
660
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 ...
- 338
2
votes
1
answer
1k
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 ...
- 261
2
votes
1
answer
132
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 ...
- 581
2
votes
1
answer
412
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 ...
- 7,177
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, ...
- 21
2
votes
0
answers
344
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 ...
- 585
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; ...
- 39
1
vote
1
answer
343
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 ...
- 11
1
vote
1
answer
76
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:
...
- 275
1
vote
1
answer
360
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 ...
- 819
1
vote
2
answers
312
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 ...
- 908
1
vote
1
answer
447
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 ...
- 3,455
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 ...
- 513
1
vote
1
answer
2k
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 ...
- 349
1
vote
2
answers
348
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 (...
1
vote
1
answer
46
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 ...
- 113
1
vote
1
answer
90
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 ...
- 2,219
1
vote
1
answer
436
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_, ...
1
vote
1
answer
530
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 ...
- 133
1
vote
1
answer
249
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 ...
- 111
1
vote
1
answer
341
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', @...
1
vote
0
answers
114
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 ...
- 65
1
vote
0
answers
944
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 ...
- 11
1
vote
0
answers
337
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 ...
- 388
1
vote
0
answers
115
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
...
- 603
0
votes
2
answers
560
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 ...
- 1