@Nikhil Verma Thank you for reaching out.
The recommendation is to use database watcher but this currently supports SQL DB and SQL MI. Support for SQL VM is planned but we don't have an ETA for now to share with customers.
For Azure SQL on VM, Unfortunately, we do not have a recommended solution at this time.
Regards,
Oury