Windows Azure Database Monitoring Extension

This extension works only with the standalone machine agent.

 

Use Case

Windows 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. Windows 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

Metrics
Azure Database/{DatabaseServer}/{DatabaseName}/Connections/Throttled Connection Count
Azure Database/{DatabaseServer}/{DatabaseName}/Connections/Terminated Connection Count
Azure Database/{DatabaseServer}/{DatabaseName}/Connections/Successful Count
Azure Database/{DatabaseServer}/{DatabaseName}/Connections/Connection Failure Count
Azure Database/{DatabaseServer}/{DatabaseName}/Connections/Total Failure Count

 

Usage

All usage metrics are scaled to 100.

Metric Path
Azure Database/{DatabaseServer}/{DatabaseName}/Usage/Average CPU Utilization Percent (x100)
Azure Database/{DatabaseServer}/{DatabaseName}/Usage/Maximum CPU Utilization Percent (x100)
Azure Database/{DatabaseServer}/{DatabaseName}/Usage/Maximum Memory Usage Percent (x100)
Azure Database/{DatabaseServer}/{DatabaseName}/Usage/Average Memory Usage Percent (x100)

 

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.

 

Version:

1.0

Compatibility:

3.7

Last Update:

10/07/2014