Hello @NM Babu ,
Thanks for the question and using MS Q&A platform.
Monitor your Azure Synapse Analytics dedicated SQL pool workload using DMVs using Azure Synapse Studio:
This article - Use Synapse Studio to monitor your SQL requests explains how to monitor your SQL requests, allowing you to keep an eye on the status of running requests and discover details of historical requests.
Monitor your Azure Synapse Analytics dedicated SQL pool workload using DMVs using Azure Synapse SQL queries.
For a programmatic experience when monitoring Synapse SQL via T-SQL, the service provides a set of Dynamic Management Views (DMVs). These views are useful when actively troubleshooting and identifying performance bottlenecks with your workload.
To view the list of DMVs that apply to Synapse SQL, review dedicated SQL pool DMVs.
For more details, refer to Azure Synapse Analytics - SQL Monitoring.
Hope this will help. Please let us know if any further queries.
- Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
- Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators