SQL Server – Connect SQL Server Profiler 2017 to Azure SQL Server

azuresql server

The title is pretty explicit, how can I connect my profiler to Azure?

So, I begin by opening the software, then a connect to my server:

enter image description here

However, I am getting this:

enter image description here

So I began to search what it could be and, I don't get it because, first Maxis a dbo_owner… But anyway, from Microsoft SQL Server Management Studio, I then tried to grant the ALTER TRACE permission (you should take a look at this post)

GRANT ALTER TRACE TO Max
GO

But I am getting the following error:

Msg 40520, Level 16, State 1, Line 1
Securable class 'server' not supported in this version of SQL Server.

Now, I just can't find the way to bypass this error. You could say "Update the server", Ok, but how?

Am I, at least, heading to the good direction in order to connect my profiler?

Thanks for any help !

Best Answer

Unfortunately, the SQL Profiler is not available on Azure SQL. To do query profiling on Azure SQL, you can use Dynamic Management Views or take a look at the Azure SQL Database Query Performance Insight.

Related Topic