AzureWatch has a great new experience now for watching Federations.

With AzureWatch it gets easier to monitor the whole deployment in an aggregate view for the following resource dimensions;

  • Database Size
  • Number of open transactions
  • Number of open connections
  • Number of blocking queries
  • Number of federated members (root database only)

Igor writes about the support in-depth here;

http://www.paraleap.com/blog/post/SQL-Azure-Federations-active-monitoring-setup-and-instructions.aspx

-cihan