Detailed Wait State Analysis for Applications and Transactions

SQL Workload Analysis for SQL Diagnostic Manager

  • 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.

No credit card required! Fully functional for 14 days

(SQL Workload Analysis is an add-on to SQL Diagnostic Manager.)

SWA

Buy Now

Includes first year of maintenance.
Volume discounts available.

Add to Cart

(SQL Workload Analysis is an add-on to SQL Diagnostic Manager.)

Need pricing options?

Request a quote for SMB or
multi-license discount pricing.

Request a Quote

(SQL Workload Analysis is an add-on to SQL Diagnostic Manager.)

Live Product Demo

See SQL Workload Analysis in action with a seasoned pro.

Request a Demo

(SQL Workload Analysis is an add-on to SQL Diagnostic Manager.)

Start for FREE No credit card required! Fully functional for 14 days

(SQL Workload Analysis is an add-on to SQL Diagnostic Manager.)