SQL Azure exposes two Dynamic Managed Views called sys.database_usage and sys.bandwidth_usage that show you the activity for your account. This wiki article shows you how to use them to understand your account usage from a billing perspective.

Read the Billing Numbers Directly From Transact-SQL.