Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

The Top SQL Statements shows the list of SQL Statements, the Total in DB data, the number of Executions, and the Database name.

Image Removed

When you click on When you  drill down into 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. This list helps you to have a faster access to other statements.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.



Scroll pdf ignore
Newtabfooter
aliasIDERA
Website | Products | Buy | Support | Community | About Us | Resources | Legal

 

...

urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse