How to install a database agent in AppDynamics?
Question ID: 106643
2
0

I need to monitor a database in my environment. How do I install a database agent for AppDynamics?

Marked as spam
Posted by (Questions: 89, Answers: 0)
Asked on January 27, 2016 9:01 pm
287 views
Answers (1)
2
Private answer

To install the database agent please follow the below instructions. There are two parts to the installation in order to start seeing metrics:

a. The agent needs to be downloaded from the AppDynamics site https://download.appdynamics.com/browse/zone/3/

b. Right click on the zip file and click properties

c. Click unblock before you unzip the file

d. Unzip the folder into the AppDynamics folder

e. Before installation be sure of the following
i. The user must have admin rights to the database
ii. Must know the database authentication credentials
iii. The application must have access to the database.

f. The controller-info.xml file needs to be configured the same as the AppAgent
i. You do not need to provide Tier and Node info

g. A batch file needs to be created to launch the database agent with the following arguments:
i. C:java -Djava.library.path=''authx64'' -Dappdynamics.agent.uniqueHostId= -Daccount.access.key-jar db-agent.jar

h. Launch an elevated command prompt and run the .bat file
i. Confirm that the agent showed up in the Controller by going to the settings wheel->AppDynamics Agents

i. You can also check the DB agent log

j. Now the collector must be configured
i. Go to Database tab at the top->Configure on the left->Collectors->New
ii. Fill in the needed information for connection

1. You can ignore the Fail Over Partner and JDBC Connection string if a special one is not being used
iii. If you want to monitor the DB's OS's hardware fill out that info and check the box.

k. The database should be reporting at this time.
i. It can take up to a minute to see metrics

l. In case of the following error ''80070005 Access is denied. SWbemLocator'' follow the directions on this link to correct.
i. https://docs.appdynamics.com/display/ADDB/WMI+Permissions+and+Security

m. If after you gain access to the database, but are getting the same error for collecting Hardware metrics then follow the directions here.
i. http://community.appdynamics.com/t5/Knowledge-Base/Resolve-Access-Denied-Error-Trying-to-Use-WMI-to-Monitor-SQL/ta-p/14142

Marked as spam
Posted by (Questions: 0, Answers: 90)
Answered on January 27, 2016 9:28 pm
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top