@Ghosh, S (Sambit) Thank you for reaching and using Microsoft Q&A Platform.
I presume you are referring to Azure dashboards , if that's the requirement and if you want to leverage Azure Monitor for collecting the data couple of pre-requisites are
- To collect your application data and send it Log Analytics Workspace using the agent, please refer to this document which further explains on how you can send your custom logs to Log Analytics workspace.
- Configure Azure SQL Analytics solution with in Log Analytics workspace for collecting data of SQL server. Please refer to this document for additional details.
- Once you have the data in Log Analytics, you can either use the existing dashboards or write custom queries and create dashboards
- You can pin the dashboards to the Azure dashboard.
Hope this information helps. Please feel free to revert back if you have any further queries.