Database Monitoring

What is Database Monitoring?

Database Monitoring is used to track database performance to create and maintain a functioning application infrastructure. information is collected from a database and any connected applications. Dynatrace then delivers automatic root-cause analysis for performance problems with your database services.

Useful Links

• Databases | Dynatrace Docs
• Detection and monitoring | Dynatrace Docs
• Analyze database services (classic page) | Dynatrace Docs
• Database observability (dynatrace.com)

Setup and Configuration

Pre-Requisite

Database monitoring technologies require specific permissions that you may not have, therefore the DBA needs to create an account for you. For special admin access you can do either of the following:

1. Contact the DBA team
2. Contact the Enterprise Monitoring team through the following form submission
   1. Be sure to provide a specific subject and description on what you need access for.
   2. e.g. Subject: Special admin access for Oracle database monitoring Description: I need a username and password for special access so that I can setup Oracle Database Insights

Configuration

Setup MSSQL Monitoring

• MSSQL is automatically deployed on every host in your environment, so there is no setup required
• The global configuration can be overrided at the host level by doing the following:

1. Go to Settings > Monitoring >Monitored technologies
2. Click the edit button next to MS SQL in the table
3. Select a host from the table
   1. You can also get here by clicking on a host and going to its settings page
4. Scroll and Select the down arrow next to MS SQL 
5. Switch to Use host configuration

Setup PostgreSQL Monitoring

1. Go to Settings > Monitoring > Monitored technologies
2. Select the edit button next to PostgreSQL in the table
3. Enter the PostgreSQL server Database name, User and Password credentials
   1. Must have “Can login” privileges
4. Select Save global configuration

Note: This can be done for individual hosts by selecting a Host and going to Host Settings and repeating the steps above

Setup Oracle Database Insights

1. Make sure OneAgent and Environment ActiveGate are installed
   1. Go to Settings > Deployment status to verify that ActiveGate is running
2. Go to Settings > Monitoring > Monitored technologies
3. Select the edit button next to Database Insights: Oracle in the table
4. Select Add database and fill in the required information
5. Select the checkbox to accept the license agreement for Oracle JDBC driver
6. Select Add database

Setup MySQL Monitoring

1. Go to Settings > Monitoring > Monitored technologies
2. Click the edit button next to MySQL in the table
3. Fill in the User and Password fields
4. Select Save global configuration

Setup MongoDB Monitoring

1. Go to Settings > Monitoring > Monitored technologies
2. Click the edit button next to MongoDB in the table
3. Fill in the User and Password fields
4. Select Save global configuration

Usage

To view which monitoring technologies are monitoring certain hosts:

1. Click on the Host you want to look at to open the Host’s page
2. Select the three dots next to the Host’s name and click on Settings
3. This General page will show you all monitoring technologies working on that host
4. You can click the down arrow next to any technology to change from global to host configuration

FAQ

Do I need a plugin to use Oracle?

• No, this is a default Dynatrace feature starting at version 1.173

Should I install OneAgent on the Oracle host?

• It is recommended that you do, so that you get a better overall picture of what’s going on in your database