To find the key points of how SQL Workload Analysis can help you, look for the ducks throughout this blog post!
It is an add-on to SQL Diagnostic Manager and a component of the IDERA Dashboard. This dashboard is the central portal for several tools from IDERA. These tools include tools for security, backup, business intelligence, and inventory management.
Identify where SQL Server issues exist. Then, drill down into periods of latency. This way, correlate all of the contributing factors to establish the root cause. Immediately know what databases are processing, drill into SQL statements, and receive actionable advice.
The web-based user interface presents a consolidated view of various key indicators of performance. By default, the unified view displays the collected data for the last day. Show longer or shorter periods by selecting the corresponding control buttons.
Drill into a more detailed perspective where there are noticeable spikes regarding the system performance. Drill in further by drawing a band around the problematic zone to reassess the contributing factors from that time.
See the impact regarding queries, CPU, and lock waits. Select a hyperlink to identify the SQL statements, the corresponding users, and the application detail. This view also shows for how long the issue persisted for any given category.
Back out of the previously selected period to show user-specific information. This information identifies where the user was accessing the system from and other associated SQL statements. Cycle through additional users in this view.
Select the top SQL statements to drill into more detailed query information. These details include what specifically are the heaviest operators per query and what percentage of the execution time they consume.
Break down the execution plan to show the specific components and the associated cost to performance. View heavily nested SQL statements with many factors contributing to the overall performance.
Pull the detail from the noisy applications into focus and drill into the impact that they had at that time. Consolidate all of the key performance indicators.
From the top level, configure the components. Manipulate panels to highlight and focus on areas of concern. In the user interface, display prominently the items that matter most.
With SQL Workload Analysis, apply continuous sampling to provide a real-time view of entire databases. Quickly drill down to isolate slow SQL statements, analyze execution plans, and see automated recommendations to tune problem statements. Improve application performance with built-in recommendations, and arrive at root cause fast with integrated operational and transactional diagnosis.