Documentation forSolarWinds Observability

Getting started with database monitoring

The guide for getting started with database picks up right after you have accepted an invitation to join your organization in SolarWinds Observability and created your user account. See SolarWinds Observability Getting Started Guide.

SolarWinds Observability can monitor the following database instance types : MySQL, MongoDB, PostgreSQL, Redis, and SQL Server. See Introduction to databases.

Verify system compatibility and open access to endpoints.

Review the SolarWinds Observability System Requirements to ensure your environment is compatible with the SolarWinds Observability Agent.

Verify your firewall settings allow communication with the SolarWinds Observability Agent endpoint. See Endpoint URIs.

Verify database privileges.

Set up your database instance to be monitored with SolarWinds Observability and ensure you have the prerequisite privileges:

Add your database instance to SolarWinds Observability.

  1. Click the plus button in the top-right corner of SolarWinds Observability, and click Database. Click the database instance type you want to monitor.
  2. Click Add Host to install a new SolarWinds Observability Agent, or choose an existing SolarWinds Observability Agent.

  3. Choose the On Host, or Off Host capture method.

  4. Enter the database instance information: instance address, username, password, bindings.

  5. Copy and execute the provided script(s) on your database instance. Verify the information entered on the Summary tab.

See the following database configuration topics for specific instructions for your database instance type:

Observe monitored database instances.

Information collected for your database instance is available in widgets in the Entity Explorer, area overviews, and custom dashboards.

  • Click Databases in the side navigation to see an overview of all your monitored database instances.

  • Review an individual entity's details in the Entity Explorer.

See Observe entities.

View resource heavy queries in the Queries Explorer.

Click Analyze > Queries. Use the Queries Explorer to display observed queries across the selected time period by total time, allowing you to determine which queries consume the most resources. See Queries Explorer.

Analyze query profiles.

Click Analyze > Profiler to open the Profiler. Use the Profiler to display useful information like the most time-consuming and frequently executed queries in your database.

Check out triggered alerts.

  1. On the Home page, click View All Alerts in the Active Alerts widget. This opens the Active Alerts view.

  2. Click an entity with issues to go to the entity details page for more information.

See Alerts.