1

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

4
  • 1
    For support, head over here: firstresponderkit.org there's a fix for that issue already Dec 31 '16 at 2:52
  • 5
    @sp_blitzErik - you should add that as an answer, with good formatting and maybe a direct link.
    – Hannah 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.