Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.1 Administrator Guide > Register a database instance for monitoring > Register a SQL Server database

Register a SQL Server database

Table of contents
No headers
Created by Anthony.Rinaldi_ret, last modified by Anthony.Rinaldi_ret on Sep 15, 2016

Views: 300 Votes: 0 Revisions: 3

Updated: November 62017

If you are monitoring a SQL Server Availability Group (AG), see Registration and licensing options for clustered environments.

To register a SQL Server database for DPA to monitor:

  1. On the DPA homepage, click Register DB Instance for Monitoring.
  2. Under Self-Managed, click Microsoft SQL Server.
  3. Click Next.
  4. Complete the wizard panels as described in the following table.
Panel Instructions
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.
    • If the SQL Server instance contains one or more Availability Groups, click Note for Availability Groups for instructions on how to register primary and secondary replicas.
    • 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).

SSL is requested by default. If the server does not support SSL, a plain connection is used.

Are you receiving errors? See DPA for SQL Server installation troubleshooting.

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.

You can also authenticate using a Windows Computer Account.

For SQL Server authentication, only the user name is required. Do not specify a domain.

Oracle Repository Tablespace

If your repository database is not Oracle, the wizard skips this step.

Choose the tablespace in the repository database to store DPA performance data for this monitored instance.

By default, the performance data is stored in the default tablespace of the repository user. However, data for monitored instances can be stored in separate tablespaces.

Select the Alert Groups

If you have no Alert Groups set up, or if this new database instance does not match the database type of the Alert Group, the wizard skips this step.

Alert Groups simplify alert configuration and help make alerting more consistent across the monitored database instances.

Select the Alert Groups you want the new database instance to join.

Summary Review the information and click Register Database Instance.
Database Instance Registration Complete Click Finish to return to the DPA homepage.
Last modified

Tags

Classifications

Public