0

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'.
Now starting diagnostic analysis
Capturing first pass of wait stats, perfmon counters, file stats
Beginning investigatory queries
Finished running investigatory queries
Waiting to match @Seconds parameter
Capturing second pass of wait stats, perfmon counters, file stats
Analyzing changes between first and second passes of DMVs
Analysis finished, outputting results
Msg 207, Level 16, State 1, Line 5
Invalid column name 'database_id'.

kit version: SQL-Server-First-Responder-Kit-20161210

Microsoft SQL Server Enterprise Edition (64-bit) version 10.50.6000.34

  • 1
    For support, head over here: firstresponderkit.org there's a fix for that issue already – Erik Darling Dec 31 '16 at 2:52
  • 5
    @sp_blitzErik - you should add that as an answer, with good formatting and maybe a direct link. – Max Vernon Dec 31 '16 at 4:52
  • @sp_BlitzErik I cann't find it – Ngài Jin Jan 3 '17 at 1:49
  • Try to execute: SELECT * FROM sys.dm_exec_requests; – McNets Jan 5 '17 at 1:35
1

Here are the two stored procedures that need to be updated.

sp_BlitzWho.sql and

sp_BlitzFirst.sql

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.