Post reply

Blocked Processes in Azure

  • March 25, 2020 at 6:31 pm

    #3737004

    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

    #3738068

    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

    #3738676

    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