Register a Sybase database

You can use mass registration to registrations to register multiple database instances, or you can register database instances using scripts that call the DPA API.

To register a Sybase database for DPA to monitor:

  1. On the DPA homepage, click Register DB Instance for Monitoring.
  2. Under Self-Managed, click SAP Sybase ASE.
  3. Click Next.
  4. Complete the wizard panels as described in the following table.
Panel Instructions
Enter Monitored Database Instance Connection Information

Enter the server name or IP address and port of the Sybase server.

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.

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

The Sybase Monitor Server does not need to be configured for SolarWinds DPA to monitor the database.

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. Next to Create Monitoring User, click Yes.
  2. Select the Authentication method, and enter the user name and password.

To specify an existing account:

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

SolarWinds DPA requires the monitoring user to have SA_ROLE and MON_ROLE privileges for data collection.

SolarWinds DPA ignores data on the monitored database instance from the specified monitoring user. Make sure the monitoring user will not cause load on the monitored instance.

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.

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