One of the CSS Engineers from Microsoft has released a diagnostic tool for SQL Azure. It’s worth a look. It’s just using standard DMO queries to pull back data, but they’re put them together inside a nice UI to help out. If you’re already a DMO super-star, this might not be useful, but if you’re looking for an easy way to gather data from your SQL Azure instance, this is a good choice. Just remember, although it wasn’t mentioned on the MS web site, I’m fairly certain you get charged for running these queries. It’s always something to keep in mind when working with SQL Azure.
Your style is very unique in comparison to other people I’ve read stuff from. I appreciate you for posting when you have the opportunity, Guess I will just book mark this web site.
Hi ScaryDBA, I wanted to mention that our Cotega monitoring service now also allows you to analyze and diagnose issues in your SQL Azure database for free. It does a similar set of analysis, plus a few extra and can be done from a browser: http://cotega.com/docs/analyze_database