Problematic SQL queries can severely reduce the performance of SQL Server and the business-critical applications that it supports. With the SQL Workload Analysis add-on, continuously monitor and analyze server workload, leverage the simple user interface that focuses on wait states and application performance, and troubleshoot problematic SQL code from changes made to database applications.
Survey of users of SQL Workload Analysis
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.
From the dashboard of SQL Diagnostic Manager, launch SQL Workload Analysis in context to isolate further the transaction causes of alerts for a quick resolution.
Easily drill down to isolate problems quickly. View details of the captured transactions to pinpoint problems.
Display and tune execution plans with actionable expert recommendations, illuminate demanding transactions, and resolve locks and latches.
View valuable real-time and historical data to help tune queries. Investigate historical query plan trends in SQL Server version 2005 and newer.
Display a quick and comprehensive overview of statistical analysis and activity trends of top database activity in the customizable dashboard.
Isolate slow SQL statements, and illuminate demanding operators.
Receive automatic expert advice to improve SQL queries, and analyze and tune execution plans.
Monitor instances remotely from a dedicated framework machine. No need to install agents, additional services, databases, tables, and extended stored procedures on the production systems.
Access a single web console via a web browser from any machine that can connect to the framework machine.
Simple architecture significantly reduces server footprint, simplifies the installation and upgrade process, and eliminates risk agents on the performance of the monitored instances.
Unify your control by running SQL Workload Analysis on cloud virtual machines with Windows — such as Azure Virtual Machine (VM) and Amazon Elastic Compute Cloud (EC2).
Monitor your SQL Server instances running on cloud virtual machines — such as Azure VM and Amazon EC2.
Save time by using the same performance monitoring tool for SQL Server databases on-premises (on your physical and virtual machines); and in the private, public, and government cloud (on virtual machines).
Get the most out of the cloud with cloud storage that is mapped as network drives or removable drives on Windows. For example, map storage to Amazon Simple Storage Service (S3) and Azure Blob Storage.
Everything you need to know, all in one downloadable PDF
See the top benefits and features of SQL Workload Analysis in this short video
Learn how to explore top monitored instances, focus on problematic occurrences, and more.
Learn about the key points of how SQL Workload Analysis can help you
Compare the features of SQL Diagnostic Manager, SQL Workload Analysis, and SQL Query Tuner
Scott Stone describes a user-centric, collaborative, holistic tuning philosophy to optimize application performance