Blocked Processes in Azure

  • Adam Bean

    One Orange Chip

    Points: 26446

    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

  • Site Owners

    SSC Guru

    Points: 80378

    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 🙂 http://whoisactive.com/docs/03_license/

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

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