question

NMBabu-1149 avatar image
0 Votes"
NMBabu-1149 asked PRADEEPCHEEKATLA-MSFT commented

How to get the last 4 hours query activity in dedicated sql pooll in azure

I need to get running/queued/completed query activity report by every fours by using sql or in Azure GUI in Dedicated SQL Pool in azure, also previous date/week/month.

azure-synapse-analytics
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I don't really know what you are talking about, but then again I don't Synapse a lot. But it seems that you have not tagged your question appropriately. You should pick a tag for Synapse.

0 Votes 0 ·
NMBabu-1149 avatar image NMBabu-1149 ErlandSommarskog ·

Hello ErlandSommarskog, I have picked the correct one (Azure-Synapse-Analytics) now.

0 Votes 0 ·

Hello @NMBabu-1149,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.


  • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.

0 Votes 0 ·

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @NMBabu-1149,

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.

198700-image.png

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.

198764-image.png

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 130616-image.png or upvote 130671-image.png 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


image.png (122.8 KiB)
image.png (56.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @NMBabu-1149,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·