tigertoolbox/Query-Performance at master · microsoft/tigertoolbox · GitHub

Name		Name	Last commit message	Last commit date
parent directory ..
QPExtendedEvents.sql		QPExtendedEvents.sql
Query Performance Dashboard.pbix		Query Performance Dashboard.pbix
readme.md		readme.md

readme.md

This is a sample powerbi dashboard to understand top queries using resources in a SQL Server. To use this:

Create and start an extended events session on your SQL Server instance to collect sample data using QPExtendedEvents.sql
Import the Extended Events file into a table.
Open the XEL file from step 1 in SSMS
from Extended Events menu, select Export to-> Table.
Change the Data Source in the Power BI dashboard to point to your table and import the data.