Workload Analysis from IDERA helps to identify where issues exist, and then drill down specifically into periods of latency, and correlate all of the contributing factors to establish the root cause. Users will know immediately what databases are processing, be able to drill into the statements, and receive actionable advice. It fits into the overall IDERA dashboard, which is the central portal for multiple IDERA tools (including security, backup, BI, and inventory management). Launching the Workload Analysis tool will present a consolidated view of various key performance indicators according to a configurable span of time. Here the last days’ worth of collected data is displayed, but we can display longer or shorter periods of time by clicking the corresponding buttons. Where there are noticeable spikes in terms of the system performance, we can drill into a more detailed perspective. To drill in further, a band can be drawn around the problematic zone, which in turn reassesses the contributing factors from that time (for example, the impact in terms of queries, CPU, and lock waits). Clicking a link identifies the queries and the corresponding users in application detail and for how the issue persisted for any given category. Backing out of the time frame previously selected will show user-specific information identifying where the user was accessing the system from, other associated statements, and even the ability to cycle through additional users. Selecting the top SQL statements will again drill into more specific query information and identify detail (including what specifically are the heaviest operators per query and what percentage of the execution time they consume, and even break down the execution plan to show the specific components and the associated cost to performance). The example shown illustrates a heavily nested statement with many factors contributing to the overall performance. From the top-level, components are configurable, and panels can be manipulated to highlight and focus on areas of concern. It is often useful to have things that matter to you prominent in the user interface. In this example, I can pull the detail from the noisy applications into focus and start to drill into the impact they had at that time — again consolidating all of the key performance indicators. If you would like to know more, you can download a trial from our website ‘’, and also visit us at ‘’.

Topics : Database Monitoring,Database Performance,SQL Query Performance,

Products : SQL Diagnostic Manager for SQL Server,SQL Workload Analysis,

An Overview of SQL Workload Analysis for SQL Diagnostic Manager

IDERA SQL Workload Analysis provides a granular breakdown of SQL Server wait states with easy drill-down to isolate problems quickly. It delivers valuable real-time and historical data to tune queries as well as actionable recommendations to improve performance. Its dashboard displays trending database activity and top utilization to identify problems and develop remedies.

Perform real-time analysis with continuous and granular SQL sampling intervals as fast as 1 sec. Know instantly where databases are spending time. Quickly isolate slow SQL statements and drill down for actionable advice. Investigate historical query plan trends. Utilize automatic recommendations to improve query performance. Boost the performance monitoring power of SQL Diagnostic Manager with detailed transactional application monitoring. Learn More →

Contact IDERA: