Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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

Register a SQL Server database

Created by Anthony.Rinaldi, last modified by Anthony.Rinaldi on Sep 15, 2016

Views: 98 Votes: 0 Revisions: 3

To register a SQL Server database for DPA to monitor:

  1. On the DPA home page, click Register DB Instance for Monitoring.
  2. Under Self-Managed, click Microsoft SQL Server.
  3. Click Next.

Enter connection information

Enter the server name or IP address and port. The default port is 1433.

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

Enter SYSADMIN credentials for SolarWinds DPA to register the database instance.

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

Troubleshooting

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

Enter the monitoring user

SolarWinds DPA gathers information through this user from the monitored instance.

You can create a monitoring user through DPA, or use an existing user.

Allow DPA to create the user

SolarWinds recommends this method because SolarWinds DPA requires special permissions that existing users may not have.

  1. Next to Create Monitoring User, click Yes.
  2. Select the Authentication method, and enter the user name and password.

Create the user manually

  1. Next to Create Monitoring User, click No.
  2. Enter the user name and password.

Authentication methods

SQL Server authentication

Do not specify a domain in the User Name field. Only the user name is required.

Windows authentication

Enter an existing Windows user. DPA cannot create a new Windows user for you. If you want to use a new Windows authentication user, you must first create it in your network domain.

Use the syntax DOMAIN\username in the User Name field.

You can also authenticate using a Windows Computer Account.

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

  1. Confirm the registration information, and click Register Database Instance.
  2. Click Finish to go to the DPA home page, or click Register Another Database Instance to continue registering.
Last modified
14:05, 15 Sep 2016

Tags

Classifications

Public