Programmatic access to SQL Azure federation structure

Question

I can't totally make out how to get the information from the Dynamic Management Views regarding the setup of SQL Azure Federations.

In particular, I'm interested in knowing what are the actual databases, their sizes, etc.  As well as the ranges that each database is allocated for key ranges.

Is there an article with such details or can someone just tell me which tables need to get joined for this info?

Thank you

---

Auto-scaling & monitoring service for Windows Azure applications at http://www.paraleap.com

Answer 1

have a look at this series of blog post by Cihan on SQL Federation Metadata:

http://blogs.msdn.com/b/cbiyikoglu/archive/2011/10/29/federation-metadata-in-sql-azure-part-1-federations-and-federation-members.aspx
http://blogs.msdn.com/b/cbiyikoglu/archive/2011/11/03/federation-metadata-in-sql-azure-part-2-history-of-changes-to-federation-metadata.aspx
http://blogs.msdn.com/b/cbiyikoglu/archive/2011/11/28/federation-metadata-in-sql-azure-part-3-monitoring-federation-operations.aspx

Answer 2

Thanks, totally missed his first post on the subject which answers most of my questions.

---

Auto-scaling & monitoring service for Windows Azure applications at http://www.paraleap.com