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-blitzfirst]

sp_BlitzFirst is a stored procedure by the Brent Ozar team. Use this tag for questions about how to use the procedure, how to interpret the output, and for troubleshooting advice.

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
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
2answers
61 views

sp_blitzfirst results to table on a linked server

I have been all over looking for the solution to logging sp_blitzfirst results to table on a linked server. I see github posts where a contributor was adding this to sp_blitz, but that's been closed ...
3
votes
1answer
173 views

sp_WhoIsActive vs sp_BlitzFirst @ExpertMode = 1

I use sp_WhoIsActive and sp_BlitzFirst (with ExpertMode paramter set to 1) to get an overview of what is happening on the SQL Server in real time. I find these to be an upgrade on sp_who, sp_who2 etc.....
4
votes
1answer
178 views

sp_BlitzCache gives a “divide by zero error encountered.”

After updating to First Responders Kit 20180901, I have a job that runs every 15 minutes and calls sp_BlitzFirst: EXEC [DBA Maintenance].[dbo].[sp_BlitzFirst] @OutputDatabaseName = 'DBA ...
15
votes
2answers
2k views

How can wait times be higher than clock time?

When I'm tracking waits with sp_BlitzFirst, I get this detail: <?ClickToSeeDetails -- For 20 seconds over the last 5 seconds, SQL Server was waiting on this particular bottleneck. -- ?> ...
0
votes
1answer
32 views

sp_blitzfirst not showing memory grant columns

I saw several videos where the know procedure sp_blitzfirst shows the memory grant columns, I even saw it working like that, but on the latest version of the first responder kit, it doesn't show those ...
2
votes
1answer
42 views

Occasional error when running sp_BlitzFirst [closed]

I have set up sp_BlitzFirst to run as a job (for the PowerBI Dashboard). Occasionally, when it runs, it gets the following error: Msg 8152, Sev 16, State 13, Line 2980 : String or binary data would ...
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 ...
3
votes
1answer
235 views

sp_BlitzFirst - File Stats Interpretation

I've had sp_BlizFirst running for a few days every 12 minutes to capture the various statistics. What I've come to realise though is that it doesn't seem to gather a lot of File Related Performance ...
1
vote
0answers
71 views

Negative values for Wait Time per Core per Sec in sp_BlitzFirst

I'm a developer in a firm that doesn't want to spend money on a DBA so i'm on my own with keeping the SQL servers healty. I checked some of Brent's videos and decided to check how hard the SQL servers ...
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 ...
-2
votes
1answer
97 views

sp_BlitzFirst doesnt work on SQL Server 2005 [closed]

Msg 139, Level 15, State 1, Procedure sp_BlitzFirst, Line 0 [Batch Start Line 3] Cannot assign a default value to a local variable. Msg 195, Level 15, State 10, Procedure sp_BlitzFirst, Line 120 [...
0
votes
1answer
78 views

Error when running sp_BlitzFirst from First-Responder-Kit-20170307

when I run EXEC sp_BlitzFirst @expertmode=1 I get Setting up configuration variables Warning: The join order has been enforced because a local join hint is used. Now starting diagnostic analysis ...
4
votes
3answers
705 views

sp_BlitzWho saving to a table

How to save result of sp_BlitzWho to a table? An option to save to table is not there compared to other procs like sp_Blitz.
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 @...
2
votes
1answer
96 views

sp_BlitzFirst: blocking_session_id not displayed in list of session_ids

I have version sp_BlitzFirst 2016-12-10. I executed the following: sp_blitzfirst @ExpertMode = 1, @CheckProcedureCache = 1, @OutputType = 'Opserver1' Below output shows SPID 124 is blocked by SPID ...
3
votes
1answer
288 views

Invalid column name 'database_id' in sp_blitzfirst

I am receiving the following in messages when running the sp_blitzfirst @expertmode = 1 on the following box: kit version: SQL-Server-First-Responder-Kit-20161210 Microsoft SQL Server Standard ...
0
votes
1answer
394 views

Invalid column name 'database_id'

I loaded the stored procedure into master and ran: dbo.sp_BlitzFirst @ExpertMode = 1 I got: Setting up configuration variables Msg 207, Level 16, State 1, Line 5 Invalid column name 'database_id'. ...
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; ...
3
votes
0answers
271 views

What could empty our cache (plan and buffer)?

If I execute sp_BlitzFirst in my server, sometimes it tells me 2 things: Plan Cache Erased Recently (indeed my plan cache is around a few hundreds MBs) (sometimes) Page Life to low (indeed my page ...
0
votes
1answer
178 views

sp_BlitzFirst fails when outputting values to tables

I have had an agent job running sp_AskBrent for some time, running with the following parameters: EXEC sp_AskBrent @Expertmode=1 ,@OutputDatabaseName = 'DBName' , @OutputSchemaName = 'dbo' , @...
1
vote
1answer
190 views

sp_AskBrent not logging queries when saving to table vs. sp_WhoIsActive

sp_AskBrent, when run as an agent job every 5 minutes is logging to a table but never seems to populate QueryText. However, sp_WhoIsActive, when also run every 5 minutes on the same SQL Server ...
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', @...