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.

EXAMPLE SOLUTIONS
• 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

100 votes

Blaž Dakskobler shared this idea · Jun 18, 2012 · Report… · Admin →

completed ·

Adam responded · Jul 21, 2017

We have now released version 7.1.0. The collection of VMware metrics is out of beta.

https://documentation.red-gate.com/display/SM7/Adding+a+VMWare+host

If you have suggestions for any improvements you would like to see, please begin a new suggestion with as much detail as possible, so we can consider where best to focus our efforts.

Thanks,
SQL Monitor Development Team

Show previous admin responses (4)

started ·

Adam responded · Jul 13, 2017

We have now released version 7.1.0. The collection of VMware metrics is out of beta.

https://documentation.red-gate.com/display/SM7/Adding+a+VMWare+host

If this meets your requirements, we’ll mark this as completed soon, but before we consider that, we’d appreciate any feedback you might have, and any improvements you would like to see.

Thanks,
Adam

started ·

Adam responded · Mar 6, 2017

We’re currently working on better VM support. If you have any further details of what exactly you would like to see, or would like to give feedback on our initial proposals, please leave a comment or email us direct at sqlmonitorfeedback@red-gate.com so we can make sure we’re considering your VM requirements.

Thanks
Adam

under review ·

Adam responded · Oct 20, 2016

We are currently considering how best to support this suggestion. If you have any further details of what exactly you would like to see, please leave a comment or email us direct – it’s great to have details about real use cases and requirements to consider while we are reviewing this.

Thanks
Adam

Daniel Rothig responded · Mar 7, 2016

Note that ManageEngine create a very good and free VM Host monitoring tool:

https://www.manageengine.com/virtualization-management/?FreeTools

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.

An error occurred while saving the comment

Blaž Dakskobler commented · January 11, 2019 5:00 AM · Report

I added a new suggestion to add Hyper-V host monitoring: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/36499981-monitor-hyper-v-hosts

Submitting...
Eric commented · March 15, 2018 12:00 PM · Report

And Hyper-V also? Seems you only added support for VMWare.

Submitting...
Anonymous commented · February 11, 2018 11:08 PM · Report

how to monitor SQL?
and what is host resource and how it is overallocated?
https://babasupport.org/printer/lenovo-customer-service/20

Submitting...
Claudio Mendes commented · February 10, 2017 3:05 AM · Report

don't forget about the storage... windows and netapp support would be appreciated

Submitting...
Blaž Dakskobler commented · April 4, 2016 3:05 PM · Report

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.

Submitting...
Dan commented · July 1, 2015 1:26 AM · Report

Any progress on this?

Submitting...
AdminPriya Sinha (Admin, Red Gate Software) commented · September 20, 2013 6:53 AM · Report

Hi Luis,

This is in our project plan but unfortunately we do not have any ETA on this yet.

Thanks,
Priya

Submitting...
Luis Martin commented · September 15, 2013 5:43 PM · Report

Hi,
Any news about this good suggestion?

Submitting...
AdminPriya Sinha (Admin, Red Gate Software) commented · August 17, 2012 2:04 AM · Report

Hi Blaz,

Thanks a lot for your feedback. We have also been discussing this internally. Hopefully we will work on this sometime soon.

Thanks,
Priya

Submitting...