Wayne has published blog article explaining how you could use these new DMVs to Troubleshoot SQL Azure database

http://blogs.msdn.com/b/wayneb/archive/2012/11/02/introducing-sys-database-connection-stats-for-troubleshooting-windows-azure-sql-database.aspx

 

MSDN Reference : http://msdn.microsoft.com/en-us/library/windowsazure/ee730906.aspx