Windows performance metrics collected by SentryOne SQL Sentry help you analyze potential problems with Windows that might be affecting the database environment. Using detailed information for network, CPU, system memory, and disk IO usage for your Windows Server and Microsoft Hyper-V environment, you can troubleshoot potential resource problems that could slow your SQL Server performance.
If you're battling SQL Server performance problems, don't overlook the possibility that the troubles might originate with Windows. To effectively troubleshoot performance problems across your environment, you need the ability to analyze Windows performance metrics to understand the full impact of Windows processes.
When monitoring SQL Server and other applications such as SharePoint running on your Windows Server, are you able to:
SQL Sentry gives you all the tools you need in a single solution to identify and diagnose Windows Server performance bottlenecks.
SQL Sentry gives you a comprehensive set of performance metrics that help you monitor your entire Windows Server and Microsoft Hyper-V environment. The Windows Server metrics are grouped by network, CPU usage, system memory, and disk I/O.
SQL Sentry gives you an overall picture of the server's performance, and lets you drill down into details to investigate potential problem areas. If you're monitoring a Windows Server running SQL Server, you can look at the Windows OS and SQL Server metrics side-by-side.
For example, if you were to see a spike in CPU usage, you might also see a spike in SQL Server Key Lookups, which is a common scenario.
If you zoom in on a specific time window of CPU usage, all other metrics graphics will be updated automatically to show their results for the same time frame.
Additional metrics are available for each guest VM hosted on the Hyper-V Server, which helps you identify whether there is a “noisy neighbor” that takes over too many machine resources.
The Performance Analysis Dashboard in SQL Sentry shows key metrics such as CPU usage, system memory, and other factors that could be contributing to SQL Server slowdowns.
Analyze Hyper-V metrics, including: