March 25, 2020 at 6:31 pm
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
March 26, 2020 at 7:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
March 29, 2020 at 2:40 am
consider adapting "sp_whoisactive" as reporting tool
but read licence agreement first 🙂 http://whoisactive.com/docs/03_license/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply