Displays a list of the most frequently executed SQL statements, including queries, and updates that have been performed on a specific monitored instance and/or a specific database.
When you drill down into any of the Statements, SQL Workload Analysis redirects you to the statement page where you can finds more detailed query information, these details helps you to identify the heaviest operators per query and the percentage of the execution time of these operators.
The Top SQL Statements page displays the performance summary; which includeds the Procedure/Batch information, any Findings and Next Steps, the SQL Statement full text, the trends of the waits, the Top Accesses Objects, and the Top Machines.
SQL Workload Analysis add-on provides a granular breakdown of wait states with easy drill-down to isolate problems quickly.
IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal