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…
Month: <span>October 2020</span>
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…