The Database analysis page shows the performance of all database calls made by your SAE application. Use it to identify which databases or SQL statements have high response times or slow requests, then drill down into traces to find the root cause.
Database analysis requires application monitoring to be enabled on a Professional Edition application.
Prerequisites
Before you begin, ensure that you have:
A Professional Edition SAE application
Application monitoring enabled for the application
View database performance
Click the Scenario-based Analysis tab, then click Database Analysis.
The page is organized into three areas:
Quick filter — filter the view by Database type, Database name, or Instance.
Trend charts — show the number of requests, number of slow requests, and average response time over time.
Database list — lists each database with its type, SQL/NoSQL statement, number of requests, average response time, and slow requests.
Analyze trends
In the trend chart area, click the
icon to open a dialog where you can:
View metric statistics for a specific time period
Compare statistics across different dates within the same time period
To switch between a column chart and a trend graph, click the
icon.
Investigate a specific database
In the database list, click the database name or Overview in the Operation column to see which services depend on that database.
To examine individual calls, click Trace in the Operation column. This opens the trace details for that database call. For more information, see Trace analysis.
Next steps
Trace analysis