Menu Performance - SQL 3D

The module, by means of a 3D chart, presents the most loaded queries according to the indicated performance statistics. In the application we have the possibility to examine the heaviest queries in terms of, for example, Elapsed Time of queries, number of executions, amount of memory utilized, number of rows processed, etc.
The queries are presented in the form of a 3D chart in descending order w/values for a given statistic over the selected time period. This makes it easy to determine when and which query most affected performance in terms of a given statistic.
The selection of the statistic for which the queries will be presented is done by changing in the Draw bar field.

Statistics are always presented for the selected time period. We also have the ability to group the displayed statistics by:

• snap (15 minutes)
• hour
• day

From the screen, you can easily add a query for detailed analysis in SQL Details by clicking on the [Plus] button next to the query ID or pointing at the chart of the query of interest, an additional menu will open, containing the option:

• View SQL details - to go to the SQL Details screen and analyze the indicated query
• View session hostory - to go to the session history screen
• Add to query hash list - to add a query to the query hash list clipboard for further analysis

Using the check boxes in the legend, we can remove individual queries from the SQL 3D view:

In addition, the user has the ability to change the presentation of the data on the screen through an additional filter Report type, which allows to change the presentation of the top queries to another view showing the top queries:

• Queries
• Procedures