Page History
The TOP SQL STATEMENTS shows the Displays a list of the most frequently executed SQL Statements, the Total in DB data, the number of Executions, and the Database name.
statements, including queries, and updates that have been performed on a specific monitored instance and/or a specific database.
When you drill down into When you click on any of the Statements, SQL Workload Analysis redirects you to the statement page . On the left side of the screen, you find the list of SQL Statements and you can select any one of them to obtain detailed information that is displayed on the right side of the screen.
In the main view of this page you find the following information:
- Summary
- Findings and Next Steps
- SQL Statement Full Text
- Total in DB Trending
- Top Accessed Objects
- Top Logins
- Top Machines
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 includes 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.
...