Documentation forSolarWinds Observability SaaS

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 SaaS and created your user account. See SolarWinds Observability SaaS Getting Started Guide.

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

Verify system compatibility and open access to endpoints.

Review the SolarWinds Observability SaaS 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 Data centers and endpoint URIs.

Verify database privileges.

Set up your database instance to be monitored with SolarWinds Observability SaaS and ensure you have the prerequisite privileges. See Database monitoring system requirements.

Add your database instance to SolarWinds Observability.

  1. Click the plus button in the top-right corner of SolarWinds Observability SaaS, and click Monitor my database performance. 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. Enter the database instance information: DBMS instance address, display name, database username, database password.

  4. Copy and execute the provided script(s) on your database instance.

  5. Verify the information entered on the Review 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 Databases > Queries to open the Queries Explorer. 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 Databases > 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.