SentryOne V Sentry provides visibility into your virtual environment so you can analyze network, CPU, memory, and storage for VMware hosts and virtual machines (VMs). Knowing CPU and system memory usage helps you troubleshoot SQL Server performance problems that are caused by problems in the virtual environment.
In order to maximize your virtual layer performance for SQL Server, SentryOne provides several VM host and guest metrics that help you identify and remedy VM performance bottlenecks that could be also be affecting SQL Server performance.
The V Sentry dashboard shows the CPU usage chart for your VMWare host. The CPU Ready Time section gives you the percentage of time that the virtual machine was ready, but couldn't get scheduled to run on the physical CPU.
High CPU ready times can be prevented by right-sizing your virtual machines and not over-provisioning your host CPU resources.
Similarly, Co-Stop is another useful VM guest metric that helps you find out the amount of time a virtual machine was ready to run but incurred a delay because of co-scheduling contentions. Sizing VMs to use the least number of virtual CPUs (vCPUs) possible minimizes the time needed for co-stop waits.
Keeping an eye on VMware memory can help you keep SQL Server running at peak performance in a virtualized environment. Because SQL Server performance so often depends on memory availability in the buffer pool, you need to know when something is affecting the amount of memory available.
VMWare uses a technique called memory ballooning to reclaim unused memory from a VM guest if the host is low on memory. You can use V Sentry to analyze whether and how frequently ballooning occurs on the VM guest running SQL Server. Memory ballooning can negatively impact your virtualized SQL Server performance—especially if your VM host is under memory pressure because memory resources are over-committed.
V Sentry provides VMware resource utilization metrics so you can troubleshoot problems in the virtual environment that might affect SQL Server.
Read more independent SentryOne reviews on TrustRadius.