How can I profile SQL Azure?

Question

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?

You will want to follow this link for information on how to monitor performance of SQL Azure: http://msdn.microsoft.com/en-us/library/windowsazure/ff394114.aspx — Igorek, Jan 20 '12 at 16:32
Possible duplicate of https://stackoverflow.com/questions/1929586/sql-azure-profiling/49217396#49217396 — Michael Freidgeim, Mar 11 '18 at 06:56

score 8 · Accepted Answer · answered Jan 23 '12 at 04:57

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?

answered Jan 23 '12 at 04:57

Craig

216
1
6

score 3 · Answer 2 · answered Jan 25 '12 at 21:55

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.

Rikard · Answer 3 · 2015-07-10T08:56:13.503

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

edited Jul 10 '15 at 08:56

answered Jul 09 '15 at 20:13

Rikard

143
7

score 1 · Answer 4 · edited Jan 10 '15 at 11:25

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)

edited Jan 10 '15 at 11:25

Paul White

67,511
25
368
572

answered Dec 13 '12 at 20:19

Matthew Steeples

663
1
7
16

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

Michael Freidgeim · Answer 5 · 2018-03-11T06:59:59.527

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

edited Mar 11 '18 at 06:59

answered Mar 11 '18 at 06:50

Michael Freidgeim

174
12

score 0 · Answer 6 · answered Jun 19 '13 at 13:37

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.

score -2 · Answer 7 · answered Jan 21 '12 at 00:09

-2

You can't run Profiler against SQL Azure.

answered Jan 21 '12 at 00:09

mrdenny

26,776
2
40
79

6

He's asking about a way to profile a SQL Azure instance. It doesn't necessarily have to be with [Profiler](http://msdn.microsoft.com/en-us/library/ms181091.aspx). – Nick Chammas Jan 21 '12 at 01:11

How can I profile SQL Azure?

7 Answers7