If you have DB’s in SQL Azure you can easily monitor them with SCOM. You just need a management pack for SQL Azure. Luckily Microsoft is offering such pack. Click on the link and download.

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=28951