- Granular wait state monitoring
- Continuous SQL sampling
- Intuitive drill down to view top activity
- Query plan tuning and recommendations
- Lock and latch resolutions
- Storage visibility and contention resolution
Continuous Wait State and Transaction Monitoring
Monitor wait states and capture transactions of applications. Get a real-time view of the entire instance and database with continuous sampling and high granularity as fast as 1 second.
Quick Drill-down for Actionable Advice
Easily drill down to isolate problems quickly. View details of the captured transactions – such as top CPU activity, waits, databases, and statements versus top logins, machines, and applications – to pinpoint problems. Display and tune execution plans with actionable expert recommendations, illuminate demanding transactions, and resolve locks and latches.
Historical Query Plan Trends
SQL Workload Analysis delivers valuable real-time and historical data to help tune queries. Investigate historical query plan trends in SQL Server 2005 and newer systems.
Integration with SQL Diagnostic Manager
SQL Workload Analysis integrates with SQL Diagnostic Manager to provide wait state and transaction monitoring. From the dashboard of SQL Diagnostic Manager, launch SQL Workload Analysis in context to isolate further the transaction causes of alerts of SQL Diagnostic Manager for a quick resolution.
Simple Web-based Dashboard
SQL Workload Analysis provides a single web-based interface that is accessible via a browser from any machine that can connect to the framework machine. The customizable dashboard displays a quick and comprehensive overview of statistical analysis and activity trends of top database activity. Quickly drill down into the details of the captured transactions to isolate slow SQL statements, illuminate demanding operators, receive automatic expert recommendations to improve SQL queries, and analyze and tune execution plans.
Agentless and Low Impact
SQL Workload Analysis monitors SQL Server instances remotely from a dedicated framework machine. SQL Workload Analysis is agentless and does not install additional services, databases, tables, extended stored procedures or anything else on the production systems. This simple architecture significantly reduces server footprint, simplifies the installation and upgrade process, and eliminates risk agents on the performance of the monitored SQL servers.