Documentation forSolarWinds Observability

Add a SQL Server database instance

Monitor your SQL Server database instance with SolarWinds Observability on a dedicated host, Amazon RDS, Google Cloud SQL, or Azure DB. Capture a robust assortment of SQL Server query metrics that give you insight into database performance and what consumes your database’s resources.

Get started

Before you start

See SQL Server system requirements to make sure your system is supported and you have the required roles, privileges, and prerequisites to monitor your SQL Server database instance with SolarWinds Observability.

To monitor your SQL Server database instance with SolarWinds Observability, complete the following:

  1. In SolarWinds Observability, click Add Data at the top.

  2. On the Add Data dialog, click Database.

  3. Click Self-hosted, Amazon RDS, Google Cloud SQL, or Azure DB from the SQL Server drop-down menu.

  4. Choose an existing SolarWinds Observability Agent on a monitored host. Click Next to continue.

    For more information about installing the SolarWinds Observability Agent on your host, see Add a self-managed host or Run the SolarWinds Observability Agent as a Docker image or Kubernetes deployment.

    If the Agent you want to use is not displayed in the wizard, make sure it has host monitoring enabled. See Enable host monitoring on an Agent.

  5. Enter the database instance address, database, database username, and database password for your database instance. Click Next to continue.
  6. If you are monitoring an Azure SQL database, you must specify a database in the Database on selected DBMS field to enable deadlocks collection.
    Click the Enable SSL toggle and enter your SSL credentials to enable SSL. 

  7. Verify the information entered on the Summary tab. Click Finish.

    To view data collected for the newly configured entity in the Entity Explorer, click the name of the Database Instance in the confirmation dialog in the lower-left corner. It may take a few seconds for data to appear for the newly created entity. See Entity Explorer for details.

See Entities in SolarWinds Observability for an overview of Database Instance entities and how they work in SolarWinds Observability.