This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.
You can monitor SQL Azure using Dynamic Management Views.
A community effort (not supported by Microsoft) for SQL Azure monitoring is http://enzosqlbaseline.codeplex.com/.
Auto-scaling & monitoring service for Windows Azure applications at http://www.paraleap.com