12

I am writing a web site that uses SQL Azure heavily. However, it is painfully slow.

Is there an easy way to profile the live SQL Azure instance?

migrated from stackoverflow.com Jan 20 '12 at 17:41

This question came from our site for professional and enthusiast programmers.

8

I have used the MVC Mini Profiler as part of an application to profile SQL Azure but depending on your application it may or may not work. What kind of tasks are you doing that need profiling?

3

It won't help you trace existing calls from your website but you can still obtain interesting performance metrics by running SQL commands from this tool directly: Enzo SQL Baseline. It offers options to load commands in parallel to simulate load and helps you compare performance metrics over multiple runs.

2

There is now a "light version" available, where you can analyze your queries and see resource consumption.

http://blogs.msdn.com/b/benko/archive/2012/05/19/cloudtip-14-how-do-i-get-sql-profiler-info-from-sql-azure.aspx

1

In addition to the other answers, you can also use the CSS SQL Azure Diagnostics tool* from Microsoft support to run some queries on the server that show you missing indexes and popular queries.

* It appears this tool is no longer available (11 January 2015)

  • The tool can't no longer be found. – user272735 Jan 10 '15 at 11:03
0

Another option is to use the Cotega Monitoring service. It has the ability to monitor and notify you of issues and also the ability to perform deep database analysis on your database to help diagnose issues such as why your database is running so painfully slow.

Disclaimer: I work on this service.

0

The most close to SQL profiler, that I found to be able work with azure sql, is sql-workload-profiler However note, that it’s a beta version of a tool, created by a single person, and it is not too convinient to use

-2

You can't run Profiler against SQL Azure.

  • 6
    He's asking about a way to profile a SQL Azure instance. It doesn't necessarily have to be with Profiler. – Nick Chammas Jan 21 '12 at 1:11

Not the answer you're looking for? Browse other questions tagged or ask your own question.