DPA 9.1 and later versions contain native support for Amazon RDS instances. If you are unable to upgrade to DPA 9.1, these instructions help you configure your earlier version of DPA to monitor SQL Server databases running in the Amazon RDS environment.
This article applies to DPA 9.0, Ignite 8.x
- Register another local instance temporarily. DPA versions 9.0 and earlier cannot register an Amazon RDS instance directly because higher level privileges are required than available. To do this, step through the registration wizard normally and register an instance on your desktop or some other test instance.
- Stop the new monitor immediately. This can be done by clicking the green arrow next to the instance on the DPA Home page or by using the Action dropdown.
- Create X$ views in the Amazon RDS instance owner's schema.
- Repoint DPA from the temporary local/test instance to the RDS instance.
- Click Options > Update Connect Info.
- Choose this new instance and click Next.
- On the next screen, update all fields to point to the RDS instance and click Next.
- The instance owner should be specified because DPA needs access to a handful of DBA and V$ views that cannot be granted to anothe user.
- Start the monitor for the RDS instance and Ignite should now be able to monitor the RDS instance.