Hello @SethuRam ,
As per the confirmation from product team, this is a known issue from the product side and product is actively working on a feature wherein we will provide read-only snapshots, every hour to create a read isolation and prevent locks issue.
I would recommend you to please subscribe to Azure updates page for latest info regarding Azure product releases.
Thank you