SQL Azure Profiling

I read开发者_开发知识库 on the MS site that SQL Azure does not support SQL Profiler. What are people using to profile queries running on this platform?

I haven't got too far playing around with SQL Azure as yet, but from what I understand there isn't anything you can use at the moment.

From MS (probably the article you read):

Because SQL Azure performs the physical administration, any statements and options that attempt to directly manipulate physical resources will be blocked, such as Resource Governor, file group references, and some physical server DDL statements. It is also not possible to set server options and SQL trace flags or use the SQL Server Profiler or the Database Tuning Advisor utilities.

If there were to be an alernative, I'd imagine it would require the ability to set trace flags which you can't do, hence I don't think there is an option at the moment.

Solution? I can only suggest you have a local development copy of the db so you can run profiler locally on it. I know that won't help with "live" issues/debugging/monitoring but it depends on what you need it for.

Edit: Quote from MSDN forum:

Q: Is SQL Profiler supported in SQL Azure?

A: We do not support SQL Profiler in v1 of SQL Azure.

Now, you could interpret that as a hint that Profiler will be supported in future versions. I think it will be a big requirement to get a lot of people on board, using SQL Azure seriously.

Update as of 9/17/2015:

Microsoft just announced a new feature called Index Advisor:

How does Index Advisor work? Index Advisor continuously monitors your database workload, performs the analysis and recommends new indexes that can further improve the DB performance.

Recommendations are always kept up-to-date: As the DB workload and schema evolves, Index Advisor will monitor the changes and adjust the recommendations accordingly. Each recommendation comes with the estimated impact to DB workload performance: You can use this information to prioritize the most impactful recommendations first. In addition, Index Advisor provides a very easy and powerful way of creating the recommended indexes.

Creating new indexes only takes a couple of clicks. Index Advisor measures the impact of newly created indexes and provides a report on index impact to users. You can get started with Index Advisor and improve your database performance with the following simple steps. It literally takes five minutes to get accustomed with Index Advisor’s simple and intuitive user interface. Let’s get started!

Original Answer:

SQL Azure now has some native profiling. See http://blogs.msdn.com/b/benko/archive/2012/05/19/cloudtip-14-how-do-i-get-sql-profiler-info-from-sql-azure.aspx for details.

Microsoft's stated position SQL Server Profiler is deprecated. As much as this is a bad idea, that's what they have said.

SQL Profile is already deprecated in SQL Server, and that’s part of the reason that it doesn’t make sense to bring to SQL DB.

What this means is you are going back 20+ years in database performance monitoring and everyone is going to have to write their own perf monitoring scripts instead of having a standard factory delivered tool that's on every server you will go to. It's tantamount to deprecating "sp_help" and making every DBA write their own. Hope you know all your DMVs inside and out... INNER JOIN, OUTER JOIN, and CROSS APPLY syntax really well.

Update as of 2017/04/14:

Microsoft's Scott Guthrie today announced a lot of new features in SQLAzure(this is called sqlazure managed instance,which is currently in preview),which are expected to be present in SQLAzure in coming months..below are them

1.SQLAgent
2.SQLProfiler
3.SQLCLR
4.Service Broker
5.Logshipping,Transactional Replication
6.Native/Backup restore
7.Additional DMV's and Xevents
8.cross database querying

References:
https://youtu.be/0uT46lpjeQE?t=1415

I have tried today a new tool suggested by Microsoft that is called Azure Data Studio.

In this tool you can download an extension called Profiler and it seems to be working just as expected.

You can use Query store feature, look here for more details: http://azure.microsoft.com/blog/2015/06/08/query-store-a-flight-data-recorder-for-your-database/

The most close to SQL profiler, that I found working in Azure SQL, is SQL Workload Profiler However note, that it’s beta version of a tool, created but a single person, and it is not too convinient to use.

SQL Azure offers following features to tune performance, profile queries in its own way, identity long running queries and much more

Intelligent Performance Performance overview Performance recommendations Query Performance Insight Automatic tuning