2. Performance Dashboard

SQL Sentry Performance Advisor shows the most important Windows and SQL Server performance metrics side-by-side in a single view, so you have the full picture at a glance. Resource utilization is integrated into the Windows network, CPU and memory charts, so you can see exactly how much of your server resources are being consumed by each SQL Server instance.

Wait Type Analysis
Wait Type Analysis shows both high-level and detailed resource utilization, giving you an instant profile for the SQL Server so you can see exactly which resources or subsystems may be causing slowdowns. Wait types are grouped together into friendly categories, and meaningless wait types are eliminated.

Network Utilization
Network utilization is displayed by SQL Server instance and by network adapter.

Disk Latency
Disk latency charts show you exactly how long reads and writes are taking for each disk and each database file, quickly highlighting disk bottlenecks.

Check out the Performance Advisor Dashboard video for quick overview.

"Within 15 minutes of downloading Performance Advisor I had at my finger tips every possible piece of pertinent information regarding my SQL Server environment. Within the first 30 minutes of running Performance Advisor I was able to identify, pinpoint and correct a blocking issue caused by legacy code that I never knew existed and was causing sporadic performance problems in our environment. Finally a truly useful and comprehensive performance monitoring tool designed by people who understand the performance factors relating to SQL Server."
-- Ken Pfeiffer, Director of Technology, Blue Sky Factory