Hi @Sai Praneeth Eranti, Thanks for posting your question.
We would like to help you onboard to Priority-based execution and understand more about your use-case where you need to set priorities for different clients from DBA standpoint. Would you be interested in a short discussion with the product team at Microsoft?
If yes, please share your contact details in this form: https://forms.microsoft.com/r/Gq6Wjv7Mmc