Blocked Processes in Azure

  • Adam Bean

    One Orange Chip

    Points: 26628

    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.


  • Site Owners

    SSC Guru

    Points: 80376

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • ebooklub

    Hall of Fame

    Points: 3900

    consider adapting "sp_whoisactive"    as reporting tool

    but read licence agreement  first 🙂

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply