Announcing the Free First Responder Kit Power BI Dashboard

What the heck is going on inside your SQL Server? Why’s it so slow?

I wrote sp_BlitzFirst to answer that question, but that only works right now. You have to be standing in front of your computer to do diagnostics when the problem strikes.

So now, you can run sp_BlitzFirst, have it log data to a table, and then later, you can analyze that data by pointing and clicking.

First Responder Kit dashboard in Power BI

Here’s a video tour of how it works.

Ready to get started?

Previous Post
[Video] Office Hours 2017/11/15 (With Transcriptions)
Next Post
How to Track SQL Server Changes with sp_BlitzFirst

21 Comments. Leave new

  • Looks like I have something to keep me busy for a little while. Woo-hoo!

    Reply
  • Wow Great, Dashboard where can i download this pbix file? Thanks

    Regards
    Sohail

    Reply
  • This is really great! Downloading now 🙂 Thanks Brent for all your great stuff!!!

    Reply
  • Hi Brent,
    just awesome, can’t wait to try it.
    Can we specify a retention period? At some point we want to delete some of the historical data to keep the size manageable.
    Thanks

    Reply
  • Tim Cartwright
    November 28, 2017 5:00 pm

    Brent, some of the checked time slices seem to be ignored. The source query for blitzfirst uses:

    SELECT * FROM dbo.BlitzFirst WHERE Priority BETWEEN 1 AND 199

    Which excludes some time slices. Is this by design?

    Reply
  • Thank you Brent – Very nice piece of work and very generous of you. I assume this will work against any Azure SQL Database database? We would just need to find a different way of keeping the statistics up to date since the SQL Agent is available, yet.

    Reply
    • Randy – you’re welcome! No clue, sorry, I don’t use Azure SQL DB.

      Reply
      • Just an FYI that Install-Core-Blitz-No-Query-Store.sql will not work when run against an Azure SQL Database, which is rather unfortunate, at least for Azure SQL Database developers. The error that is generated is “Reference to database and/or server name in ‘master.sys.databases’ is not supported in this version of SQL Server. And, of course, the proc cannot be run against master directly because Azure doesn’t permit that. The same problem exists with Install-Core-Blitz-With-Query-Store.

        Reply
        • Randy — none of our scripts are guaranteed to work in Azure. Same with sp_WhoIsActive.

          They add and remove stuff without notice, and it’s impossible for a small shop to keep up with.

          Thanks!

          Reply
  • Batch Requests are in my data but the “line” for Batch Request does not appear on the Power Bi client? any idea on where to start looking as to why? It’s like BlitzFirstResults_PerfmonStatus_Deltas (data) fell-out of the report somehow? And yes I’m a NOOB to Power Bi – be gentle. 🙂

    Reply
    • Reloaded the report from the FRK.zip and that fixed it. And yes somehow the perfmon drop out of the report – odd?! Cheers!

      Reply
  • Niiiceeee!! I would say that on first iterations of FirstResponderKit there was something similar, but more rudimentary? I mean, also a job to gather information from sp_Blitz (before there was BlitzFirst) and later we could check that data to analyze it

    Reply
  • Anyone having luck opening the .pbix file in the newest version of Power BI Desktop (October 2017)? I’m getting the error “is corrupt or an invalid report file”.

    Reply
    • M – bad news, October 2017 was quite a while ago. You’ll want to update your Power BI Desktop for starters, and try re-downloading the file. (I just literally opened it during a class 15 minutes ago, so I know it works.)

      Reply
      • I’m going to go sit in the corner with my dunce cap now. I was right-clicking the files on GitHub and clicking “Save link as…” instead of left-clicking the file and then downloading from the next screen. Interestingly, the files were named with the .pbix and .pbit extensions. The files worked when I actually downloaded them. I also took the time to update to the Feburary build of Power BI Desktop. Thank you.

        Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}