{"id":6340,"date":"2015-11-23T22:40:42","date_gmt":"2015-11-23T21:40:42","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/trying-appdynamix-monitoring-application-from-user-to-database\/"},"modified":"2015-11-23T22:40:42","modified_gmt":"2015-11-23T21:40:42","slug":"trying-appdynamix-monitoring-application-from-user-to-database","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/trying-appdynamix-monitoring-application-from-user-to-database\/","title":{"rendered":"Trying AppDynamix – monitoring application from user to database"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.
\nI like to come upon new monitoring software that help to go quickly from user response time to root cause. And I love applications that can be installed easily and at which I can give a try without reading pages of manual. <\/p>\n

At DOAG 3rd floor I’ve visited the AppDynamics booth and immediately wanted to install the trial version and give it a try.
\n
\n\"appdynamics\"<\/a><\/p>\n

Download and install<\/h3>\n

From the AppDynamics website, there is a 15 days trial version that you can download. I’ve downloaded the Linux version (controller_64bit_linux-4.1.7.0.zip) because I want to try it on our Oracle Tuning workshop VM. It’s 500MB and when you unzip you get two files:<\/p>\n

\noracle@vmoratun201:\/tmp\/appdynamics\/ [DB1] unzip controller_64bit_linux-4.1.7.0.zip\nArchive:  controller_64bit_linux-4.1.7.0.zip\n  inflating: controller_64bit_linux-4.1.7.0.sh\n  inflating: license.lic\n \noracle@vmoratun201:\/tmp\/appdynamics\/ [DB1] ls -l\ntotal 1084416\n-rw-r--r--. 1 oracle oinstall 559790650 Nov 20 21:33 controller_64bit_linux-4.1.7.0.sh\n-rw-r--r--. 1 oracle oinstall 550634894 Nov 23 20:35 controller_64bit_linux-4.1.7.0.zip\n-rw-r--r--. 1 oracle oinstall      1997 Nov 22 12:43 license.lic\n<\/code><\/pre>\n
Yes… a 500MB ‘.sh’ to run as a shell script. If you look at it, it embeds some binary code at the end of the script.
\n\"appdynamics002\"<\/a>
\nFunny isn’t it? I like this idea…<\/p>\n
Then just run it<\/p>\n
\noracle@vmoratun201:\/tmp\/appdynamics\/ [DB1] sh controller_64bit_linux-4.1.7.0.sh\nUnpacking JRE ...\nPreparing JRE ...\nStarting Installer ...\n<\/code><\/pre>\n
You have a graphical wizard and after a few next-next-next you can connect to the server with a browser:
\n\"appdynamics011\"<\/a><\/p>\n
Monitoring database<\/h3>\n
Then it’s very easy. Look at what you can monitor:<\/p>\n
\"appdynamics012\"<\/a>
\nAnd I choose ‘database’.<\/p>\n
I have to set database type (Oracle) and the url of my controller.<\/p>\n
The wizard ask you download the database agent (dbagent-4.1.7.0.zip). I just get the url from there and download it in my VM with wget:<\/p>\n
\noracle@vmoratun201:\/tmp\/appdynamics\/ [DB1] wget https:\/\/download.appdynamics.com\/self_service\/agent\/dbagent\/2\n--2015-11-23 21:30:12--  https:\/\/download.appdynamics.com\/self_service\/agent\/dbagent\/21cea4f9066d3131435bbf01\nResolving download.appdynamics.com... 54.244.244.230\nConnecting to download.appdynamics.com|54.244.244.230|:443... connected.\nHTTP request sent, awaiting response... 200 OK\nLength: 39230821 (37M) [application\/zip]\nSaving to: \u201cdbagent-4.1.7.0.zip\u201d\n \n36% [=======================>                                            ] 14,253,827   191K\/s  eta 2m 4s\n<\/code><\/pre>\n
Then follow the instructions:<\/p>\n
\nunzip dbagent-4.1.7.0.zip\njava -jar db-agent.jar \n<\/code><\/pre>\n
The agent knows where is the controller (probably from the download url) and connects to it once started.
\nI am still in the wizard, waiting to receive that connection:
\n\"appdynamics013\"<\/a>
\nand a few minutes later:
\n\"appdynamics014\"<\/a><\/p>\n
I really like those simple easy things… It tells you to wait 3 minutes and 3 minutes later you get it.<\/p>\n
The wizard asks connection information to my database (host, port, service, user, password) and it’s ready to monitor:<\/p>\n
\"appdynamics016\"<\/a><\/p>\n
Not very exiting yet? I’ve run SwingBench for few minutes.
\nLet’s click on ‘Metrics Browser’ and choose some statistics to monitor:<\/p>\n
\"Capture019\"<\/a><\/p>\n