Submit a ticketCall us

Cloud Workloads: Meet Your New Hybrid IT Reality
Have you found yourself in that evolving, hybrid IT grey area and wondering if cloud workloads are now part of your purview? And if so, will monitoring cloud workloads require a new set of dedicated cloud monitoring tools? Your answers: yes, they should be, and no, they don’t.

Find out how SolarWinds® Server & Application Monitor (SAM) can help you monitor your cloud workloads side by side with your on-premises workloads. Register Now.

Home > Success Center > Database Performance Analyzer (DPA) > Database Performance Analyzer Getting Started Guide > Register database instances > Register a single SQL Server database instance

Register a single SQL Server database instance

DPA_GS_Home.png

You must register all of the database instances that you plan to monitor with DPA. You can register an individual instance using the Register Instance Wizard, or you can register multiple instances.

DPA can monitor many database types. This example shows you how to register a SQL Server database. For information about registering a different type of database instance, see Registering a database instance in the DPA Administrator Guide.

Before you start

Before you run the Register Instance wizard, make sure:

  • The database instance is a version that DPA can monitor.
  • You have credentials to a login with SYSADMIN privileges for the SQL Server database instance.

Run the wizard

  1. Near the top-right of the DPA homepage, click Register DB Instance for Monitoring.
  2. Complete the wizard panels as described in the following table.

Panel Instructions
Select Database Instance Type Select Microsoft SQL Server.
Enter Monitored Database Instance Connection Information
  1. Enter connection information for the SQL Server instance:

    • If the SQL Server Browser service is running, enter the server name or IP address and the instance name in this format: Server\Instance.

    • Otherwise, enter the server name or IP address and the port number.

    SolarWinds DPA monitors all databases within the instance. If more than one instance exists on the server, you must register each instance separately in DPA.

  2. Select the type of authentication you want to use. If Mixed Mode was selected during the SQL Server installation, you can choose either option.
  3. Enter a SYSADMIN login that DPA can use to register the instance.

    DPA does not use or store these credentials after you complete the wizard.

    • For Windows authentication, enter <DOMAIN>\<username> in the SYSADMIN User field.

    • For SQL Server authentication, enter the credentials that you enter on the Connect to Server dialog in SQL Server Management Studio (with Database Engine as the Server type).

Enter the Monitoring User

Create or specify the account that DPA will use to gather information. To ensure that the account has the required permissions, SolarWinds recommends creating a new account.

To create a new account:

  1. Click Yes.
  2. Select SQL Server as the authentication method. (DPA cannot create a new Windows account.)
  3. Enter a user name and password for the new account, or accept the default values.

To specify an existing account:

  1. Click No.
  2. Select either authentication method.
  3. Enter the user name and password of an existing account.

    For Windows authentication, enter <DOMAIN>\<username> in the Monitoring User field.

Summary

Review the information and click Register Database Instance.

Database Instance Registration Complete Click Finish to return to the DPA homepage.

View performance data for the database instance

If you register a database instance within the 14-day trial period, DPA begins monitoring the instance immediately. After the trial period, you must allocate a license to monitor the database instance.

When DPA is monitoring an instance, the homepage shows summary information about the instance.

File:Success_Center/New_Articles/DPA_Getting_Started_Guide/030/020/gs-viewinstancedatasummary.png

Click the instance name to view detailed information about that instance. For more information, see Investigate a SQL statement causing long waits.

File:Success_Center/New_Articles/DPA_Getting_Started_Guide/030/020/gs-viewinstancedatadetail.png

Last modified

Tags

Classifications

Public