Page History
...
The Main Query view consists of the following major components that allow you to customize your view:
Anchor selectview selectview
Select the type of view that you want to be displayed
| selectview | |
| selectview |
The View Selection of the Main Query view allows you to choose from a variety of views to explore query data. The following views are available:
...
| Info |
|---|
Duration (ms) is the default view of the Main Query view. |
Anchor groupby groupby
Use Group By to organize your view
| groupby | |
| groupby |
Once you have selected a view, use the Group By option to choose from the following type of objects for query aggregation:
...
| Info |
|---|
Application is the grouping by default in the Main Query view. |
Anchor filtering filtering
Use Filtering to customize your view
| filtering | |
| filtering |
Filter options in the Main Query view allow you to focus only on the information you want to be displayed. You can include or exclude specific applications, databases, users, SQL text, and more from the Query Monitor results through filters. The following filter options are available:
- Application
- Databases
- Users
- Clients
- SQL (Include SQL text matching or exclude SQL text matching)
- Advanced Filters
Anchor timeframe timeframe
Select a time period to display query data
| timeframe | |
| timeframe |
You can choose the time period to display in the Main Query view. This selection limits the queries to only those that run during the specified time period. You can select from a broad range of built-in time periods or specify start and end dates, and times for the period. The Time box includes the following options:
...
| Tip |
|---|
To switch to a shorter time frame, click the larger time bucket. For example, clicking a month in a monthly graph modifies the time period to the selected month and grouping to days. |
Anchor analyzedata analyzedata
Analyze your query data
| analyzedata | |
| analyzedata |
On the right-hand side of the overall view, query data is displayed based on your View, Group By, and filtering selections. The Data view is designed to provide good visualization of the selected data and enable you to drill down into problem areas. The Data view is composed of the following elements:
Header
Provides View, Group By, Period, and filter criteria information.
Graph
Chart area which displays the aggregated query results that meet the filtering criteria.
List
Displays data selected for the view in list form. There are several list options according to your Group By selection in the Main Query view.
...
You can return to the higher level view by clicking
by the list name.
Access the Queries tab
SQL Diagnostic Manager provides two paths to access the Queries tab. The first access path is by selecting the Queries tab of the single instance dashboard. You can also click the query category icon of a specific instance in the thumbnail sub-view.