Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Database Performance Analyzer (DPA) > Monitor a SQL Server database instance in Amazon RDS

Monitor a SQL Server database instance in Amazon RDS

Table of contents
Created by Interspire Import, last modified by Anthony.Rinaldi_ret on Jun 28, 2016

Views: 375 Votes: 0 Revisions: 9

Overview

DPA 9.1 and later supports Amazon RDS instances. For earlier versions, use these instructions to configure monitoring for SQL Server databases running in the Amazon RDS environment.

Environment

  • DPA 9.0
  • Ignite 8.x

Steps

These steps assume that the RDS Instance owner account will be used for monitoring.

 

Step 1: Register a different instance temporarily. DPA cannot register an Amazon RDS instance directly because higher level privileges are required than available. To do this, step through the registration wizard as you would normally.

 

Step 2: 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.

 

Step 3: Repoint DPA to the RDS instance.

  • Click on Options > Support > Database Query Tool
  • Run the query select id, name from cond order by name to get the Confio ID for the newly registered local instance. Enter that value in the next step for <dbid>.
  • Tell DPA where the SQL Server RDS instance is located by updating its row in the COND table. The RDS information can be obtained from the RDS Management Console for the instance. The <display> below can be anything that you like.
update cond set name = '<display>',
      username = '<rds>', password = '<rds>',
      machine_name = '<rds>', 
      conn_host = '<rds>', 
      instance_name = '<rds>'
where id = <dbid>

For example:

update cond set name = 'SQL RDS Instance',
      username = 'confio', password = '<password>',
      machine_name = 'confiosql.czl9q3fmotaz.us-west-2.rds.amazonaws.com',
      conn_host = 'confiosql.czl9q3fmotaz.us-west-2.rds.amazonaws.com',
      instance_name = 'confiosql.czl9q3fmotaz.us-west-2.rds.amazonaws.com'
where id = 124

 

Step 4: Disable the O/S metric collections in DPA since these metrics are not available in the RDS environment. Run the following on the DPA repository where the RDS instance is being registered. Substitute the same value for <dbid> here as in Step 3.

insert into con_metrics_disabled (db_id, entity_type, metric_name, branch_name, disabled_flag,disabled_reason) 
      values (<dbid>, 'DB', 'CPU Queue Length','IGNITE',1,'Manually Disabled for RDS');
insert into con_metrics_disabled (db_id, entity_type, metric_name, branch_name, disabled_flag,disabled_reason) 
      values (<dbid>, 'DB', 'CPU Utilization','IGNITE',1,'Manually Disabled for RDS');
insert into con_metrics_disabled (db_id, entity_type, metric_name, branch_name, disabled_flag,disabled_reason) 
      values (<dbid>, 'DB', 'Disk Queue Length','IGNITE',1,'Manually Disabled for RDS');
insert into con_metrics_disabled (db_id, entity_type, metric_name, branch_name, disabled_flag,disabled_reason) 
      values (<dbid>, 'DB', 'Memory Paging Rate','IGNITE',1,'Manually Disabled for RDS');
insert into con_metrics_disabled (db_id, entity_type, metric_name, branch_name, disabled_flag,disabled_reason) 
      values (<dbid>, 'DB', 'Memory Utilization','IGNITE',1,'Manually Disabled for RDS');
insert into con_metrics_disabled (db_id, entity_type, metric_name, branch_name, disabled_flag,disabled_reason) 
      values (<dbid>, 'DB', 'Physical I/O Rate','IGNITE',1,'Manually Disabled for RDS');
insert into con_metrics_disabled (db_id, entity_type, metric_name, branch_name, disabled_flag,disabled_reason) 
      values (<dbid>, 'DB', 'Physical Write Rate','IGNITE',1,'Manually Disabled for RDS');
insert into con_metrics_disabled (db_id, entity_type, metric_name, branch_name, disabled_flag,disabled_reason) 
      values (<dbid>, 'DB', 'Physical Read Rate','IGNITE',1,'Manually Disabled for RDS');

 

Step 5: Update an DPA parameter so SQL text can be collected.

  • From the DPA Home page, click the Action > Advanced Options next to the RDS instance.
  • Select the Support Options check box.
  • Click the SQLTEXT_SQLSERVER_USE_DMV advanced option, and set to True.

 

Step 6: Restart the DPA PI Server Windows service where DPA is installed (not the RDS instance).

 

Step 7: Start the monitor for the RDS instance. From the DPA home page, click the arrow to the left of the instance or use the Action dropdown.

Last modified
15:19, 28 Jun 2016

Tags

Classifications

Public