Refresh of Windows Azure Service Bus EAI & EDI Labs; SQL Azure Database Query Usage (CPU) Graph in Management Portal; AzureWatch Now Support SQL Azure Federations Monitoring Announced

The refresh of Windows Azure Service Bus EAI & EDI Labs release is now available and the capabilities showcased in this release enable two key scenarios on Windows Azure:Enterprise Application Integration (EAI) which provides rich message processing capabilities and the ability to connect private cloud assets to the public cloud.Electronic Data Interchange (EDI) targeted at […]

The refresh of Windows Azure Service Bus EAI & EDI Labs release is now available and the capabilities showcased in this release enable two key scenarios on Windows Azure:

  • Enterprise Application Integration (EAI) which provides rich message processing capabilities and the ability to connect private cloud assets to the public cloud.
  • Electronic Data Interchange (EDI) targeted at business-to-business (B2B) scenarios in the form of a finished service built for trading partner management.

You can read more on how to use the new capabilities in the MSDN Documentation.

To signing up for the labs is free of charge, all you need to do is:

Note, "there is no SLA promise for labs, so you should not use these capabilities for any production needs," Azure team said.

EAI & EDI capabilities enhancements include:

  • "The bridge has been enhanced to process both positional and delimited flat files along with xml messages. It can also pull a message from your existing FTP server and then process it further
  • Flow of messages within a bridge is no longer a black box: we have exposed the operational tracking of messages within it along with its metadata
  • Creating and editing schemas has become simpler and easier using the schema editor we have added as a first-class-experience in our Visual Studio project. Yes, we heard your feedbackJ. Fetching schemas from another service is also simpler using an integrated wizard experience
  • You can now send messages to the bridge in UTF-16, UTF-16LE and UTF-16BE too apart from UTF-8
  • We have further enriched the Mapper functionality to support number formatting, timezone manipulations and different ways to generate unique Ids. To handle errors and null data, we let user configure the behavior of the runtime
  • The Visual Studio Server Explorer experience to create, configure and deploy LOB entities on-premises has become simpler using a new wizard which is much easier to use
  • From the EDI Portal you can delete agreements to reduce the clutter. You can also change agreement settings and redeploy agreements
  • EDI messages can be tracked for one or more agreements and the view is exposed through the EDI portal. The view also supports search and correlation of messages and acknowledgements
  • We now support out-of-the-box archiving in EDI. All EDI messages can be archived and downloaded from the EDI portal
  • We have added preliminary support for send side batching in EDI based on message count. This would be enhanced to include more batching criteria in future releases.
  • We have also improved the EDI Portal performance and made improvements to the error messages
  • There are UX enhancements all across which should make your experience smoother," the team informs.

Also, within the SQL Azure Management Portal, customers can now check their service usage with the help of various graphs. "One of these graphs is the SQL Azure Database Query Usage (CPU) graph, which provides information on the amount of execution time for all queries running on a SQL Azure database over a trailing three month period," inform Azure team.

SQL Azure Database Query Usage (CPU) Graph in the Management Portal

To learn more about the SQL Azure Management Portal, you can view this video:

And, the AzureWatch has a great new experience now for watching Federations. " By using AzureWatch, database administrators can now actively monitor all federated members and be immediately notified when any one of them is getting too large, too slow, or needs other special attention."

"Experienced AzureWatch users and newcomers alike will find the setup of SQL Azure Federations to be relatively simple. A new option on the navigation explorer enables entry of federations that need to be monitored. "

AzureWatch for Monitoring Federated Databases in SQL Azure

Once the monitoring is running, AzureWatch will query the root database and all federated members once per minute in order to store, aggregate and evaluate vital statistics. 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)

You can read more about AzureWatch on Igor's blog post.