Windows Performance Metrics collected by SentryOne Win 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. These metrics are also built into SQL Sentry, the flagship SentryOne monitoring product for SQL Server.
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 like SharePoint running on your Windows Server, are you able to:
SentryOne Win Sentry gives you all the tools you need in a single solution to identify and diagnose Windows Server performance bottlenecks.
SentryOne Win 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.
Win 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 Win 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:
"Monitoring real-time Windows Server health metrics and SQL Server metrics presented in a graphical interface that makes issues imminently apparent is where SQL Sentry excels. It allows a very quick response to current server conditions (both Windows and SQL Server) when issues occur."
—Terry Anthony, Senior Database Developer, EnableComp