Hey all,
What's the appropriate way to setup a blocked processes report in Azure SQL?
I see blocked process threshold is set to 20, this can't be changed right? There's no profiler, but data factory has a plugin.
Do you have to use extended events out to a storage account?
Basically I just want to setup a process to monitor blocking during nightly ETL to pinpoint some contention.
Thanks