AppDynamics for Databases
2.9.x Documentation
The Reports menu provides pre-defined reports including:
Reports use the time context (start/end time) from the Main window and therefore may be pre-populated with data. You can change the time range for a specific report and click Run Report.
Supported Databases |
Description |
---|---|
DB2, MySQL, SQL Server, Sybase, PostgresSQL |
Uses the activity data collected by the agent to display the Top N SQL statements in a time-series view. Each SQL statement is color-coded, with “Other SQL” displayed at the top of the graph in pink. The Y-Axis displays elapsed time in seconds. |
SQL Server 2005 and above |
Uses data collected by Dynamic Management View (DMV) queries to display Top N SQL Statements in a time-series view. The Y-Axis can be switched between CPU, Elapsed Time, Execution Count, Logical Reads, Logical Writes, Physical Reads and CLR Time. |
Oracle |
Uses data collected by v$ queries to display the Top N SQL statements in a time-series view. The Y-Axis can be switched between CPU, Elapsed Time, Executions, Buffer Gets, Rows Processed, Disk Reads and Parse Calls. |
Supported Databases |
Description |
---|---|
Oracle |
Similar to the Top SQL Report for Oracle, it allows filtering by SQL Command Type such as Select, Insert, Alter, etc. |
Supported Databases |
Description |
---|---|
Oracle |
Similar to the Top SQL Report for Oracle, but rather than reporting on each SQL statement it groups statements into pre-defined groups. You can set up groups in the Agent Manager, or alternatively configure an automated PL/SQL --> SQL group. |
!
Supported Databases |
Description |
---|---|
All Databases |
This report displays data in a table and highlights the time spent in each wait state for each SQL statement. |
Supported Databases |
Description |
---|---|
All Databases |
This report displays time-series data on Wait Events (states) within the database. Each distinct wait is color-coded, and the Y-axis displays time in seconds. |
Supported Databases |
Description |
---|---|
All Databases |
This report shows a summary of Elapsed Time, Executions and % CPU of the database instance host compared with a historic baseline. You can select the baseline based on a previous point in time from the last 6 weeks. |
Supported Databases |
Description |
---|---|
SQL Server |
This report gives information on Physical I/O performed by the database instance. |
Oracle |
This report gives information on Physical I/O performed by the database instance. |
Supported Databases |
Description |
---|---|
DB2, MySQL, SQL Server, Sybase, PostgreSQL |
This report allows compares two points in time. The report displays 3 time-series graphs with side-by-side comparisons of time period 1 (T1) and time period 2 (T2). The first graph displays Top SQL (in the same format as the Top SQL report). The second graph displays %CPU consumption of the database instance host. The third graph displays database waits (in the same format as the Database Wait Report). Tabular data at the bottom of the report displays comparisons of elapsed time differences between T1 and T2 on a per-SQL statement basis. |
SQL Server 2005 and above |
This report compares two time periods using DMV collected data. |
Oracle |
This report compares two time periods. It is possible to compare based on the Top N Queries chosen based on Elapsed Time, CPU, Executions, Buffer Gets, Rows Processed, Disk Reads etc. |
Supported Databases |
Description |
---|---|
All Databases |
This report can be used to show a high level summary of Elapsed Time, Executions and % CPU of the database instance host for a long period of time. The report can be filtered to just show specific days of week or hours of day. |
Supported Databases |
Description |
---|---|
PostgreSQL |
This report gives a summary of performance and activity within the PostgreSQL instance for a specific time period. |