AppDynamics for Databases

2.9.x Documentation

The AppDynamics for Databases Controller runs on Apache Tomcat. The controller can run on either a physical or virtual machine on either Windows or Linux. One controller can manage multiple collectors.

Collectors are Java applications. There is a different collector for each type of system monitored:

  • Database collectors use JDBC over TCP/IP to query IBM DB2 LUW, Microsoft SQL Server, Microsoft SQL Azure, MySQL, Oracle, MongoDB, PostgreSQL, Pivotal Greenplum and Sybase ASE/IQ databases.
  • Server collectors use SSH to query Linux and UNIX based systems, and WMI calls to query Windows systems.
  • Storage collectors use the NetApp ONTAP API to query NetApp FAS controllers or the SanTricity API to monitor E-Series arrays over HTTP or HTTPS.

The graphical user interface (GUI) to AppDynamics for Databases is presented on a web browser using Java Server Pages. The user interface provides historical insight into the monitored systems. By default, the data displayed is refreshed once every minute.The default port number to connect to the AppDynamics for Databases GUI is 8090. 

Collected metrics, alerts, collector configurations, and other relevant data are stored in a MySQL 5.6 database named dbtuna.

 

  • No labels