Version 2.7.0 of the SQL Server Monitoring tool has now been released. The tool includes 26 services (query statistics, missing indexes, capacity metrics, …), and one Power BI Desktop report…
Category: <span>SQL Server</span>
This blog is part of the blog series named SQL Server Monitoring. Purpose To provide a wrapper around the Who Is Active solution made by Adam Machanic. Sources When executing…
This blog is part of the blog series named SQL Server Monitoring. Purpose To get a baseline of the server wait statistics. Sources This feature queries the 2 DMV’s sys.dm_os_waiting_tasks…
This blog is part of the blog series named SQL Server Monitoring. Purpose To show the configured triggers. Sources This feature queries the DMV sys.triggers which returns information for database…
This blog is part of the blog series named SQL Server Monitoring. Purpose To get a baseline of the size of the tables in the databases. Sources This feature queries…
This blog is part of the blog series named SQL Server Monitoring. Purpose To show the age of the index statistics when they were last captured. Sources This feature queries…