Windows Performance Metrics: Identify Issues Affecting SQL Server

What are Windows Performance Metrics in Win Sentry?

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.

You'll find this feature in:

SQL SentryWin Sentry 

Are Windows Server issues slowing your SQL Server environment?

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:

  • Quickly view all server activities in real-time or for a specific timeframe to identify performance issues that are slowing down your business-critical applications?
  • Monitor side-by-side how certain SQL Server activities, like increases in user connections or SQL transactions, impact the performance of the underlying Windows Server?
  • Easily view CPU and memory usage for each Hyper-V Virtual Machine (VM) guest running on your server machine?  

SentryOne Win Sentry gives you all the tools you need in a single solution to identify and diagnose Windows Server performance bottlenecks.

Get Windows and Hyper-V metrics at your fingertips

 

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.

SentryOne_WinSentry_184

 

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.

What You Can Do with Win Sentry Performance Metrics

  • View a comprehensive set of Windows OS metrics and Hyper-V metrics
  • Analyze Windows OS metrics, including:
    • Network metrics such as total network utilization
    • CPU Usage metrics such as total processor time percentage across all processors on the server
    • System Memory metrics such as memory usage by SQL Server process and other processes
    • Disk IO metrics such as read and write latency by physical disk
  • Analyze Hyper-V metrics, including:

    • Network utilization by each Virtual Machine (VM) guest
    • CPU Usage metrics such as usage time by each guest
    • System Memory metrics such as physical memory usage by each guest
    • Disk IO metric such as read throughput across all VMs belonging to the host

"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