AppDynamics for Databases
2.9.x Documentation
...
Supported Databases | Description |
---|---|
DB2, Microsoft SQL Server, Microsoft SQL Azure Database, MySQL, Sybase, PostgreSQL | Uses the activity data collected by the collector 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. |
Microsoft SQL Server 2005 and above, and Microsoft SQL Azure Database | 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. |
“Other SQL” is a bucket of all other distinct SQL queries outside of the Top N. For example, if your report shows the top 10 SQL, then “Other SQL” represents all other distinct queries from the 11th upwards.
The Top 10 often represents 80%+ of the activity, but in your case it looks like it’s only about 20% i.e. they have lots of unique SQL queries sharing the resource consumption. You could reduce the amount of “Other SQL” by increasing N i.e. display Top 20 etc
Supported Databases | Description |
---|---|
Microsoft 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. |
...