How to Obtain the query Performance Metrics - Azure Synapse

Question

Any best practice available to Demonstrate the Ability to obtain Query Performance metrics for batch and interactive queries

Answer 1

Hi @Jaydeep Chakrabarty ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

Please refer this document to check various metrics along with corresponding definitions and also for details related to Dynamic Management Views (DMVs) available to query. As Synapse is still evolving and features are getting added gradually to make it more effective. Synapse team is currently working on improving the monitoring metrics and I would recommend to upvote and share more monitoring metrics needed to this idea in feedback forum that is closely looked by our Product team and implement in future releases. Also, Azure portal enables to integrate with other Azure monitoring services such as Azure Monitor (logs) with Log analytics to provide a holistic monitoring experience for not only your data warehouse but also your entire Azure analytics platform for an integrated monitoring experience.

Hope this helps! Please let us know for further queries and we will be glad to assist.

----------------------------------------------------------------------

• Please accept an answer if correct. 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.