Versions Compared

Key

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

Amazon RDS Query Monitor is a useful SQL Server tool that allows you to log and analyze queries. Query Monitor allows you to establish criteria for the queries to analyze the queries returned by:

  • Discovering the worst performing queries.
  • Visualizing complex SQL Queries.
  • Pinpointing root causes.
  • Generating recommendations to improve the performance of SQL databases and queries.

The Sessions tab includes the Signature Mode, Statement Mode, Query History, and Query Waits.

Signature Mode

The Query Monitor Signature Mode view includes all active query information, automatically reduced to the signatures grouped accordingly.

Image Added

Statement Mode

The Statement Mode view is where you go to drill down into a specific execution of a particular query. It provides all the detail you may need to diagnose a specific problem with a query.

Image Added

Query History

Query History allows you to track the performance of a query over time.

Image Added

Query Waits

The Query Waits view displays the queries on your SQL Server instance with the longest wait times. By default, the chart at the bottom of the view displays the query waits over time and allows you to further investigate based on Statements, Applications, Databases, Clients, Sessions, and Users.


Scroll pdf ignore
Newtabfooter
aliasIDERA
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