Just for my record, I wanted to post a few interesting posts regarding ‘SCOM Azure Management Pack’:

http://blogs.msdn.com/b/walterm/archive/2011/02/01/setting-up-performance-counters-in-your-web-and-worker-roles.aspx

http://blogs.msdn.com/b/walterm/archive/2011/02/14/adding-azure-application-monitoring-to-scom-2007-r2.aspx

http://blogs.msdn.com/b/walterm/archive/2011/03/18/configuring-azure-diagnostics-performance-counter-monitoring-in-scom-2007-r2.aspx