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.

0
votes
2answers
37 views

Can sp_Blitz, sp_BlitzCache, or sp_BlitzFirst identify what queries caused a major growth operation to occur on a particular log file?

I'm currently logging the outputs of sp_Blitz, sp_BlitzCache, and sp_BlitzFirst regularly (via SQL jobs). A particular database's log file grew somewhat exponentially and I believe I can see the ...
0
votes
0answers
29 views

Is there a “@SkipChecks…” parameter equivalent for sp_BlitzFirst and sp_BlitzCache?

Silly question, how do I skip over certain databases when running sp_BlitzFirst and sp_BlitzCache? I'm on SQL Server 2008 R2 - Enterprise (10.50.4042.0). (I'm not sure how to get the First Responder ...
1
vote
0answers
25 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
1answer
99 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
76 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
224 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
191 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
35 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
43 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
202 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
270 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
78 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
240 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
126 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
104 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
79 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
737 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
102 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
302 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
412 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
519 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
301 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
182 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
195 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
175 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', @...