June 8, 2017 at 10:43 pm
Hi Guys,
I am new in Azur. In SQL server I can use "SQL Profiler" to find out what's going on in our application. However, I am using Azur backend DB.
My question is, how can I try and see what's is going on in frontend application i.e (Which SP is calling and which query is running)
Any help would be great appreciated.
Thank You.
June 9, 2017 at 4:44 am
Extended Events is the route I believe
https://blobeater.blog/2017/02/06/using-extended-events-in-azure/
June 9, 2017 at 7:07 am
Yep, absolutely, Extended Events.
You also have access to the same DMVs to query the cache, sys.dm_exec_requests, etc., and you have Query Store, which is on by default in Azure SQL Database. However, BLOB EATER has it right if you want detailed query calls, Extended Events is the way to go.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply