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

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

1 Answer 1

Reset to default
1

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

sp_BlitzWho.sql and

sp_BlitzFirst.sql

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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