Key resource metrics

The Resources view gives you access to the key metrics you need to monitor for optimal resource performance.

You can view the current value of these metrics or plot them from now up to 12 hours in the past. These charts can help you identify performance patterns or unexpected peaks in activity.

• 30 minute period, with a data point every 5 minutes
• 1 hour period, with a data point every 10 minutes
• 12 hour period, with a data point at each refresh interval (by default, every 6 minutes)

TIP	Some resource metrics are OS metrics. To successfully monitor OS metrics, ensure OLE Automation is enabled on the monitored SQL Server instance and in the SQLdm Console.

Summary

The Summary filter presents key metrics representing the most important performance indicators across all resources. When this server is a virtual machine (VM), the Summary filter displays the CPU and memory usage consumed by the VM workload.

• Response Time (in milliseconds)
• CPU Usage
  • SQL Server usage (percentage)
  • Total usage (percentage)
• Memory Usage
  • Used by SQL Server (in kilobytes)
  • Allocated by SQL Server processes (in kilobytes)
• Disk Busy (percentage)
• VM CPU Usage (percentage)
• VM Memory Usage (percentage)

CPU Metrics

The CPU filter presents key metrics representing the most important performance indicators for the processors on this server.

• CPU Usage
  • SQL Server (percentage)
  • Total (percentage)
• Processor Queue Length (size)
• Processor Time
  • Privileged (percentage)
  • User (percentage)
• Call Rates
  • Compiles (number of, per second)
  • Re-Compiles (number of, per second)
  • Batches Received (number of, per second)

Disk Metrics

The Disk filter presents key metrics representing the most important performance indicators for the physical disk on this server.

• SQL Server Physical I/O
  • Page Reads (average number per second)
  • Page Writes (average number per second)
  • Checkpoint Writes (average number per second)
  • Lazy Writer Writes (average number per second)
  • Read Ahead Pages (average number per second)
• SQL Server Physical I/O errors (number of)
• Disk Reads Per Second (number of)
• Disk Transfers Per Second (number of)
• Disk Writes Per Second (number of)
• Disk Milliseconds Per Read (average time spent per disk read, in milliseconds)
• Disk Milliseconds Per Transfer (average time spent per transfer operation, in milliseconds)
• Disk Milliseconds Per Wait (average time spent waiting for process to finish, in milliseconds)

Memory Metrics

The Memory filter presents key metrics representing the most important performance indicators for your server memory.

• Memory Usage
  • Used by SQL Server (in kilobytes)
  • Allocated by SQL Server processes (in kilobytes)
  • Total Used (percentage)
• Paging (number of paging operations per second)
• Buffer Cache Hit Ratio (percentage)
• Procedure Cache Hit Ratio (percentage)
• Page Life Expectancy (in seconds)

Session Metrics

The Session filter presents key metrics representing the most important performance indicators for sessions connected to this server.

• Response Time (in milliseconds)
• Active Sessions (number of)
• Blocked Sessions
  • Block Sessions (number of)
  • Lead Blockers (number of)
  • Total Deadlocks (number of)
• Packets Sent (number of)
• Packets Received (number of)
• Batches Received (number of)