Windows Performance Metrics

What are Windows Performance Metrics in SQL Sentry?

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.

You'll find this feature in:

SQL Sentry

Download Free Trial

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 such as SharePoint running on your Windows Server, are you able to:

Quickly view all server activities in real-time or for a specific time frame to identify performance issues that are slowing down your business-critical applications?
Monitor side-by-side how certain SQL Server activities, such as 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?

SQL 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

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.

SQL Sentry Windows Server and Hyper-V Performance Monitoring

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.

What you can do with SQL Sentry's Windows Server and Hyper-V 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 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 metrics such as read throughput across all VMs belonging to the host

More about Windows performance metrics

More resources

Ready to end your database performance problems?

Download a SQL Sentry trial

See for yourself how SQL Sentry can help you achieve optimal database performance.

Schedule a SQL Sentry demo

Learn more about how SQL Sentry can help you troubleshoot and prevent database performance problems. Register to attend a public demo or schedule a one-on-one session.

Learn more about SQL Sentry

Discover how you can quickly find and fix SQL Server performance problems with SQL Sentry, which delivers proven scalability, easy-access dashboards, and visibility across your entire database environment.