Identify if virtualization hosts are congested
CONTEXT: We are monitoring virtual servers that share a VM host.
PROBLEM: If host resources are overallocated, the physical resources can be contended even if the virtual resources aren't. This is not easy to spot in SQL Monitor.
• Add virutal host counters for VMware and Hyper-V to the analysis graph: CPU, Memory, disk...
• Integrate with a Virtualisation monitoring solution to connect the dots more easily
Note that ManageEngine create a very good and free VM Host monitoring tool:
The capabilities of that tool is a few steps above the kind of virtualisation monitoring you can get from any SQL Server monitoring tool I’ve seen, and also above what we could build into SQL Monitor in the medium term: VIrtualisation is quite a complex technology!
My advice in the interim is to use a dedicated tool for VM host monitoring: The stuff you get thrown in with a SQL Server tool is in most cases not worth it.
Blaž Dakskobler commented
Hi Daniel. Main benefit of having such options inside SQL Monitor would - imho - be to more easily correlate timings of some events. Other than that, it makes sense that dedicated hypervisor monitoring tools offer more.
Any progress on this?
This is in our project plan but unfortunately we do not have any ETA on this yet.
Luis Martin commented
Any news about this good suggestion?
Thanks a lot for your feedback. We have also been discussing this internally. Hopefully we will work on this sometime soon.