Tips
General Tips that don’t fit into one of the other categories.
Enroll Today!
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
General Tips that don’t fit into one of the other categories.
Should I be worried that your tool has largest number of TotalLogicalIO compared to all other activity on a server?
It really depends on what else your server is doing. On SQL server with heavy load, using the Historic Monitoring feature many add 2% to 3% to the CPU and overall I/O. If a server is sitting mostly idle, database health monitor doesn’t add any more load, however it does add a greater percentage.
In version 2.2 released on December 5th 2015, there were a number of performance improvements to the historic monitoring that should reduce the overall I/O and CPU load.