In SQL Monitor, I want to...

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

94 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Blaž DakskoblerBlaž Dakskobler shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Daniel RothigDaniel Rothig responded  · 

    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.

    5 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base