Database Administrators Stack Exchange
Database Administrators 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.

See https://www.brentozar.com/askbrent/ for details about the procedure, and to download it.

39 questions
15
votes
2 answers

How can wait times be higher than clock time?

When I'm tracking waits with sp_BlitzFirst, I get this detail: Should that read "for 20 times over the last 5 seconds?" …
Robert Rice
  • 153
  • 1
  • 7
11
votes
1 answer

How to export the output of sp_AskBrent?

We have an instance that randomly spikes the CPU. I want to create an alert that fires on CPU over 90% and automatically calls a job that runs sp_AskBrent and emails me the output. However, the output is unreadable in either Text or HTML output. It…
Mick
  • 111
  • 2
6
votes
1 answer

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 sp_AllNightLog, Line 16 [Batch Start Line…
Henrik Staun Poulsen
  • 2,249
  • 2
  • 23
  • 41
6
votes
1 answer

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... Can anyone explain what, if any difference…
SE1986
  • 2,142
  • 4
  • 30
  • 61
6
votes
2 answers

Running sp_AskBrent with @ExpertMode = 1 in PowerShell

I am trying to run sp_AskBrent from PowerShell using Invoke-SQLCmd and capture its output in a variable: $query = "EXEC SAIDBA.monitoring.sp_AskBrent @Seconds=10;" $check = Invoke-Sqlcmd -ServerInstance $ServerInstance -Query $query …
Jefferson B. Elias
  • 536
  • 6
  • 19
4
votes
1 answer

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 Maintenance', @OutputSchemaName = 'dbo', …
Matthew Brook
  • 41
  • 1
4
votes
3 answers

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.
Kumar D
  • 41
  • 2
3
votes
1 answer

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 Stats apart from I/O stalls. Is there enough info…
Philip
  • 372
  • 1
  • 2
  • 13
3
votes
1 answer

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 instance does capture the queries. I'll get an Execution…
user103537
  • 83
  • 5
2
votes
1 answer

Cannot install sp_blitzfirst on sql azure db

I'm trying to install Brent Ozar's SP_BlitzFirst on a user database on an Azure SQL Database instance. However, I get the error: The module 'sp_BlitzFirst' depends on the missing object 'sp_MSforeachdb'. The module will still be created; however,…
Andrew Richards
  • 125
  • 3
2
votes
3 answers

Should I use a temp table or join

I am creating a stored procedure in sql server 2019 that needs to use multiple select statements to get a parent row and then its related data. I have the primary key clustered value for the parent so the first query will at most return 1…
Joshua Grippo
  • 140
  • 1
  • 9
2
votes
1 answer

Can sp_BlitzFirst pass the @ExpertMode parameter to sp_BlitzWho

When running sp_blitzFirst @expertmode = 1 the first result set(result set of sp_blitzwho)does not return nearly as many columns and it does in Brent's video. With a little troubleshooting it was uncovered that the reason this is happening is…
Steve Rybak
  • 21
  • 1
2
votes
1 answer

Occasional error when running sp_BlitzFirst

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 be truncated. [SQLSTATE 22001] This is actually…
Darrell
  • 125
  • 3
  • 10
2
votes
1 answer

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 143, however SPID 143 did not show up in any of the…
Greg
  • 582
  • 1
  • 4
  • 14
2
votes
1 answer

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 Edition (64-bit) version 10.50.6000 Setting up…
DisturbedMaynard
  • 21
  • 1
1
2 3