Month: <span>October 2020</span>

Power BI Desktop SQL Server

Updated August 29, 2021. Purpose To show the age of the index statistics when they were last captured. Sources This feature queries the DMV dm_db_stats_properties which returns the date of the…

Power BI Desktop SQL Server

Updated August 29, 2021. Purpose To get a baseline of the size of the tables in the databases. Sources This feature queries the DMV sys.dm_db_partition_stats which returns page and row-count…

Power BI Desktop SQL Server

Updated August 29, 2021. Purpose To get a baseline of the server wait statistics. Sources This feature queries the 2 DMV’s sys.dm_os_waiting_tasks and sys.dm_os_wait_stats which returns information about the wait…

Power BI Desktop SQL Server

Updated January 26, 2022. Purpose To provide a wrapper around the Who Is Active solution made by Adam Machanic. Sources When executing the stored procedure sp_WhoIsActive the result of who…

Power BI Desktop SQL Server