Enable SQL Profiler for SQL Azure
While the query performance analyzer in the Azure portal is great, it does not allow for the real-time capturing of queries. Instead, it takes a sample and only shows the most "expensive" queries.
It can be very difficult to figure out problem queries without SQL Profiler working in SQL Azure. Adding support for this would be a huge win.
Andrew Stanton commented
Extended events might be fine some of the time but I cant start them most of the time via SSMS or ADS anyway. I have a support case open for that, maybe it will be fixable.
However there just is not a way to see the lock escalation pattern of a stored proc better than SQL Profiler can show it.
I tried to use the Sql Profiler for Sql Azure today and I am getting an error message:
Failed to start session: An exception occurred while executing a Transact-SQL statement or batch.
Looking at extended events doesn't see to do exactly what I need. I need to see exactly what the database is calling at the time to aid in troubleshooting. Hard to know what exactly the app is calling if you can't see the calls live.
Joel Tipke commented
Azure Data Studio and the SQL Profiler extension worked for me.
Morgan Smith commented
Hey MS, Create and support a tool like Chris's and we'll quit harping on SQL Profiler.
I know, let's replace a relatively simple tool with a complex, multi-step process to get profile data.....
Thanks for nothing!
Dimitri Furman commented
SQL Trace and SQL Profiler are deprecated. Similar functionality is provided by Extended Events. Please see https://docs.microsoft.com/en-us/azure/sql-database/sql-database-xevent-db-diff-from-svr, and http://www.mssqlgirl.com/using-extended-events-on-azure-sql-database.html.