Stack Exchange Network

Stack Exchange network consists of 175 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

Questions tagged [sp-blitz]

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

1
vote
0answers
21 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 ...
0
votes
0answers
25 views

Azure Managed Instance Log file Larger than Data File

Good Afternoon, I am working with the Brent Ozar tools on an Azure SQL Server Managed Instance. Once of the things that came up when I ran the sp_Blitz procedure was that I had several databases that ...
0
votes
1answer
43 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 ...
1
vote
1answer
42 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
0answers
55 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 ...
0
votes
2answers
72 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
18 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
145 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
552 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
122 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
90 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
35 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
100 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
40 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 ...
1
vote
1answer
335 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
141 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
306 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
132 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
145 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
180 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 ...
1
vote
0answers
67 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
585 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
45 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
39 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 ...
-1
votes
0answers
41 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
311 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
343 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
220 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
121 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
52 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
359 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
70 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
95 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
2k 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
138 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
442 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
486 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; ...
0
votes
2answers
369 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
52 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
169 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
85 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
124 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
581 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 ...
9
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
516 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
62 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
189 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, ...