Also, in below 6 minutes YouTube video, Brent provided a nice demo of how effective it can be in Performance TroubleShooting of SQL Server using the First Responder Kit and BI Dashboard.
Personally, I find it very easy and useful and thus going to share few key points as below:-
1) Default Dashboard Screen showing Batch Requests/Sec and Waits stats for particular date-time frame. It is also showing Quick Diagnosis data collected by sp_BlitzFirst and Resource-Intensive Queries collected by sp_BlitzCache which can be filtered according to Wait Type.
Also we can Drill down through a specific Batch/Query statement running in time frame selected.
2) The Drill Down of Query/Batch provides me data for Query Performance Over Time. It also, suggests various issues in each execution of Query.
I hope you all would love it eventually as I do. Thanks 🙂
I am Microsoft Certified Professional having 10+ years of experience in SQL Server Querying, Database Design, and Administration. I am fond of Query Tuning and like to automate things using TSQL & PowerShell. I also have experience of implementing end-to-end Data Warehouse solution, and Data Migration using ETL tools SQL Server Integration Services (SSIS), Pentaho Business Analytics, and have designed Database Inventory through PowerShell, Python, and Django etc.