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

Question

question

NMBabu-1149 asked May 2, '22 PRADEEPCHEEKATLA-MSFT commented May 10, '22

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

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

ErlandSommarskog · May 02 at 09:12 PM

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 ·

NMBabu-1149 ErlandSommarskog · May 03 at 03:39 AM

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

0 ·

PRADEEPCHEEKATLA-MSFT · May 09 at 05:10 AM

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 or upvote button whenever the information provided helps you.

0 ·

Answer 1 · 2022-05-04T07:23:24.19Z

PRADEEPCHEEKATLA-MSFT answered May 4, '22 PRADEEPCHEEKATLA-MSFT commented May 10, '22

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.

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

image.png (122.8 KiB)

image.png (56.4 KiB)

· 1

5 |1600 characters needed characters left characters exceeded

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

PRADEEPCHEEKATLA-MSFT · May 10 at 07:43 AM

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 ·

question