The Database Calls page helps you locate SQL performance issues by displaying the call count, average duration, and related call traces for each SQL statement.
View SQL analysis results
-
Log on to the Managed Service for OpenTelemetry console. In the left-side navigation pane, click Applications.
-
On the Applications page, select a region in the top navigation bar and click the name of the application.
In the left-side navigation pane, click Database Calls. On the SQL Analysis tab, review the following metrics:
A chart showing the number of SQL calls per minute and the average response time for the selected time range.
The number of SQL calls and the average response time for specific SQL statements for the selected time range.
Locate a specific SQL statement in the list, then use the Actions column:
Click Call Statistics to view per-minute call volume and average response time for that statement.
Click Trace Query to view all related traces on the Traces tab.
Specify a time range
You can select a predefined time range or specify a custom time range.
In the upper-right corner of the page, click the date and time picker and select a predefined time range, such as Last 30 Minutes, Today, or This Week.
If no predefined time ranges meet your business requirements, select Custom. Select a start time and an end time in the calendar or enter a start time and an end time, and then click OK.
NoteThe date format is
YYYY-MM-DDand the time format isHH:MM.