Detailed Wait State Analysis for Applications and Transactions

SQL Workload Analysis for SQL Server

  • 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 for SQL Server 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 for SQL Server

SQL Workload Analysis for SQL Server integrates with SQL Diagnostic Manager for SQL Server to provide wait state and transaction monitoring. From the dashboard of SQL Diagnostic Manager for SQL Server, launch SQL Workload Analysis for SQL Server in context to isolate further the transaction causes of alerts of SQL Diagnostic Manager for SQL Server for a quick resolution.

Simple Web-based Dashboard

SQL Workload Analysis for SQL Server 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 for SQL Server monitors SQL Server instances remotely from a dedicated framework machine. SQL Workload Analysis for SQL Server 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 for SQL Server 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.)