Updated May 1, 2022. Purpose To get a baseline of the server performance counter metrics. Sources This feature queries the DMV sys.dm_os_performance_counters which returns a row per performance counter that…
Category: <span>Power BI Desktop</span>
Updated August 29, 2021. Purpose To get a baseline of the number of logical reads that the server handles, as well as the amount of elapsed and worker time. Sources…
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…
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…
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…
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…