Register a single SQL Server database instance
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, including Oracle, Sybase, IBM DB2, MySQL, and Azure SQL. This example shows you how to register a Microsoft SQL Server database. For information about registering other types of database instances, see Register a database instance for monitoring 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
- To open DPA, enter one of the following URLs in a web browser:
If you have not registered any database instances, the Register Instance wizard opens automatically.
If the wizard does not open automatically, click Register DB Instance for Monitoring near the top left of the DPA homepage.
Complete the wizard panels as described in the following table.
|Select Database Instance Type||Select Microsoft SQL Server.|
|Enter Monitored Database Instance Connection Information||
|Enter the Monitoring User||
Create or specify the SQL Server or Windows 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:
To specify an existing account:
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 activate a license to monitor the database instance.
When DPA is monitoring an instance, the homepage shows summary information about the instance.
For the first two hours after you register the instance, data is shown only on the homepage. After two hours, all DPA pages are populated.
Click the instance name to view detailed information about that instance. For more information, see Investigate a SQL statement causing long waits.