THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Aaron Weiker said:

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

http://msdn.microsoft.com/en-us/library/ff394114.aspx

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 (www.cotega.com) 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

Leave a Comment

(required) 
(required) 
Submit

About BuckWoody

http://buckwoody.com/BResume.html

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement