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) > DPA 11.1 Administrator Guide > Register a database instance for monitoring > Register an Amazon RDS for SQL Server database

Register an Amazon RDS for SQL Server database

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

Views: 45 Votes: 0 Revisions: 4

Updated: November 62017

To register an Amazon RDS for SQL Server database for DPA to monitor:

  1. On the DPA homepage, click Register DB Instance for Monitoring.
  2. Under Amazon RDS, click Amazon RDS for SQL Server.
  3. Click Next.
  4. Complete the wizard panels as described in the following table.

If registration fails because your DPA server cannot connect to the instance's server, see DPA database registration failure when attempting to register a database on an external network.

Panel Instructions
Enter Monitored Database Instance Connection Information

Enter the server name or IP address and port.

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.

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

Enter an Amazon RDS Master User for SolarWinds DPA to register the database instance. If you do not want to enter the Master User that created the database instance, use the SQL statement below to create a new Master User. Replace dpa with the new user name.

CREATE LOGIN [dpa] WITH PASSWORD=N'Password1';
GRANT ALTER ANY LOGIN TO dpa;
GRANT VIEW SERVER STATE TO dpa WITH GRANT OPTION;
GRANT VIEW ANY DEFINITION TO dpa WITH GRANT OPTION;
GRANT VIEW ANY DATABASE TO dpa WITH GRANT OPTION;
ALTER SERVER ROLE [processadmin] ADD MEMBER [dpa];
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