This extension works only with the standalone machine agent.

Use Case

Microsoft Azure is an Internet-scale computing and services platform hosted in Microsoft data centers. It includes a number of features with corresponding developer services which can be used individually or together. Microsoft Azure Database Monitoring Extension queries Azure Database system tables to fetch the metrics. For more information on Azure system tables please visit http://msdn.microsoft.com/en-us/library/dn282162.aspx

Prerequisite

Create database in azure and get the JDBC connection string. To get the connection string please follow this link http://azure.microsoft.com/en-us/documentation/articles/sql-data-java-how-to-use-sql-database/#determine_connection_string

Installation

1. Download and unzip the file 'AzureDatabaseMonitor.zip' to {machineagent install dir}/monitors
2. Open monitor.xml and configure the Azure arguments

<argument name="config-file" is-required="true" default-value="monitors/AzureDatabaseMonitor/config.yml" />

config-file : yml file where we define the Azure Database configurations

example yml configuration

   # Azure Database particulars

   databaseServers:
    -   serverName: "gkbzse0m18"
        databasePort: "1433"
        databaseNames: [AppdTest, AppdTest2]
        adminUser: ""
        adminPassword: ""
    -   serverName: "hd57z9kvth"
        databasePort: "1433"
        databaseNames: [TestDb2]
        adminUser: ""
        adminPassword: ""

   #prefix used to show up metrics in AppDynamics
   metricPrefix: "Custom Metrics|Azure Database|"

Note: For each database configuration 2 queries will be fired to Azure. Please be careful while configuring more databases.

Metrics

The following metrics are reported.

Connections

Usage

All usage metrics are scaled to 100.

Custom Dashboard

Contributing

Always feel free to fork and contribute any changes directly via GitHub.

Support

For any support questions, please contact help@appdynamics.com.