Use the Server Settings Databases pane to manage monitored database instances. All existing database agents display in the list. You can pause and resume databases, and create and configure new database agents.
Click Settings > Dynatrace Server > Databases to access the Databases pane. Click Create to create a new database agent.
Select the type of the database, Collector for the Agent to connect to, and specify the Agent name in the appropriate fields. You won't be able to change those afterwards. Then set appropriate values for the rest of the fields.
Create and configure a database agent
When specifying database user for the Agent make sure to grant necessary permissions for it. Each database agent requires the proper permissions. Permissions needed for the Database Agent and the respective SQL statements are listed in the Database Agent Configuration Permissions section.
These settings are required for all database agents.
Database Type: Select the type of database to be monitored from the list. This selection determines the other information required to create the database agent and displays the JDBC connection string for the selected database type.
Agent Name: Specify a unique name for the agent.
Collector: Lists available collectors defined for the server. Select the collector used to host the database agent. The collector must have a network connection to your database instance.
Host, Port: Enter the host name and port number for the database. The host name maps the Database Agent to system profiles using the PurePath connection pool information. The host value can either be the database hostname or an IP address. When entering the host, you can click the gear icon next to the Host field and define additional host names for the database agent.
Instance name: (SQL Server) may be left blank. Identifies which SQL Server instance of those running on a host is to be monitored. If left blank a default/unnamed instance is used. A default instance may not exist.
SID/Service name: (Oracle) Identifies a database instance of those running on a host to be monitored.
Database name: (DB2) Identifies a database instance of those running on a host to be monitored.
Database User, Database Password: Enter the credentials used to access the database.
Windows authentication, Domain: (SQL Server) Specifies the LMv2/NTLMv2 domain to use for authentication.
SSL: (SQL Server) Specifies if and how to use SSL for secure communication. For more information, see JTDS documentation.
Enable top SQL and wait states analytics: Select this check box to capture and compute the top SQLs and wait states displayed in the web interface.
Add Agent (application environment configuration only): When adding a database while configuring an application environment, click this button to add the database being configured to the list of configured database agents.
Test Connection: Once you enter required configuration information, click this button to test the database connection. For an Oracle Database RAC type, this button tests the database connection and automatically discovers nodes upon a successful test.
See Database Agent FAQ for information if you have database connection issues.
Configure Oracle database
These settings are specific to setting up database agents for Oracle and Oracle RAC databases.
Service Name: This is the TNS alias that you give when you remotely connect to your database. The service name is recorded in the
Tnsnames.ora file on your clients. Oracle RAC has a different service name for each instance.
For Oracle, the service name can be the same as the SID, but you can also give it any name you want. For Oracle RAC, there is different service name for each instance.
SID: The Oracle SID is a site identifier that uniquely identifies your instance/database. Use one of the following commands in Oracle to find the Oracle SID:
select instance from v$thread;
select * from global_name;
select distinct sid from v$mystat;
The SID also displays in the database and database communication channel details of the Transaction Flow dashlet.
Accept Dynatrace Redistribution Agreement: Select this check box to accept Dynatrace Redistribution Agreement. Required to add new or modify existing Oracle agents. Setting is common with Performance Warehouse configuration screen.
Configure Microsoft SQL Server
These settings are specific to setting up database agents for Microsoft SQL Server databases.
Instance Name: Corresponds to either the default instance name (
MSSQLSERVER) or a named instance for the SQL database. A named instance is determined by the user during setup. In SQL Server, you can enter
select @@servername + '\' + @@servicename to find the used SQL Server instance name.
Configure DB2 database
Database name: Corresponds to the value of the CREATE DATABASE
database-name parameter. in DB2, you can use the
db2 list db directory command to find database names.