SQL Azure Monitoring
The actual setup of SQL Azure monitoring is fairly straightforward. Upon successful upgrade to the latest version of Control Panel (v2.0 at the time of this post), simply visit the newly available SQL Azure option in your Control Panel explorer.
Add databases to be monitored by right clicking anywhere in the SQL Azure Instances window.
Fill out connection information for your SQL Azure database
Upon successfull setup of a SQL Azure database, AzureWatch will automatically instrument the capture of five key metrics: Database size, # of Open connections, # of Blocking Queries, # of Open Transactions and general Response Time.
It is time to aggregate the metrics over some periods of time, so that AzureWatch can properly alert you in case your Rules trigger.
Setting up of aggregations is performed via the next option in explorer: Aggregate Metrics.
Color ranges will help AzureWatch highlight key metrics on the dashboard
And finally, the setup of alerts can be performed from the Rules screen located underneath Aggregate Metrics
Congratulations! We just instructed AzureWatch to notify us if in the last 5 minutes our SQL Azure database was running any blocking queries.