WAD2SQL - Windows Azure Diagnostics to SQL

What it Does

WAD2SQL is a Windows Service that will copy Azure Diagnostics (WAD) data from table storage to a SQL server. Diagnostics data currently supported are:
  • Windows Event Logs
  • Windows Performance Counters
  • Application Trace Data

NOTE: In order to use WAD2SQL, WAD must be enabled within your Azure application

Why?

The largest reason for the application is to allow for a known access mechanism to data, to expand:
  • Existing reporting infrastructures (EG - SQL Reporting Services) does not easily support using Azure Tables as a data source.
  • Azure Tables have limited index options making it hard to query.

What is the Status on the Project?

I wrote this application to address a need for my day job. I am passively working on the project and thinking of the next features to implement, including
  • Improve indexes based on defined use cases
  • Caluclate hourly aggregations for performance
  • Provide SQL Reporting Services Reports
  • Pull Service Metadata (to allow for better reporting)
  • Pull IIS log information
  • More-better support using an Azure hosted SQL database
  • Improve the installation process
  • Allow for data retention pruning

Last edited Dec 13, 2012 at 5:58 AM by ChadTillekeratne, version 2