THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Buck Woody

Carpe Datum!

Monitoring SQL Azure For Performance

In SQL Server Azure, there are no Dynamic Management Views (DMVs) or Performance Monitor Objects and Counters that you can access, so you can’t run your standard performance monitoring that way. I suspect that as time goes on, SQL Azure will have some instrumentation, but for the time being, you’ll have to go with a different metric – round trip throughput.

What I mean by that is you’ll need to measure the start of a transaction and it’s completion. In the end, this is the only metric that matters anyway, but it is helpful to know what to fix – and this metric doesn’t help you with that.

What’s been working for me is to develop my queries locally using all my tricks and tools, and then post those up to SQL Azure. While it’s not a one-to-one map, it does seem to fit the bill for now. I’ll keep you posted.

Published Tuesday, December 22, 2009 7:33 AM by BuckWoody



Aaron Weiker said:

Just wanted to note that there is a new section on MSDN around using DMV's to track performance.

March 2, 2011 12:38 PM

Buck Woody said:

Aaron- thanks for that link!

March 2, 2011 2:31 PM

Cotega - SQL Azure Performance Monitor said:

Hi Buck, our service ( offers some instrumentation for monitoring SQL Azure performance.  Please let us know if you would be interested in taking a look.

May 7, 2012 7:44 PM
New Comments to this post are disabled

About BuckWoody

This Blog


Privacy Statement