Windows Hyper-V Host Monitoring is a capability in SentryOne SQL Sentry that gives you insight into Hyper-V performance metrics so you can identify and address problems that might affect other systems in the environment, including SQL Server databases.
If you have SQL Server databases running in a Hyper-V environment, performance problems caused by virtual machine (VM) resource contentions could affect database performance, too.
When the host server has limited hardware resources available, those resources must be shared among the virtual machines and by the Windows hypervisor (Hyper-V). If you have limited resources, then performance of databases and applications running in that virtual environment could suffer.
Knowing whether you're running into network, CPU, memory, disk IO, or physical storage space problems is critical to overcoming these types of bottlenecks.
No matter what your virtual environment setup is, you need a monitoring tool that helps you monitor, diagnose, and optimize your physical and virtual hosts.
That’s where SQL Sentry from SentryOne comes in.
SQL Sentry gives you a unique view of resource utilization for all your Windows Server and Hyper-V hosts.
The SQL Sentry dashboard helps you monitor real-time and historical host-level metrics and usage for Hyper-V. It provides a per-VM breakdown of resource utilization so that you can find the “noisy neighbor” that could be causing performance issues.
The dashboard is broken down into two panels.
The left side shows the resource utilization—including network, CPU usage, system memory, and disk IO—of the host.
The right side of the dashboard shows which guest VMs are making use of those host resources, helping you identify which guests are using more than their fair share.
SQL Sentry also shows Disk Activity and Disk Space, indicating the activity and size of the Hyper-V VHDX files. In the Disk Activity view, you can also view disk latency. SQL Sentry provide powerful "Jump To" functionality so you can quickly navigate between the host and any SentryOne monitored virtualized guest to see and drill down on what might be causing resource contention.