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

NM Babu 1 Reputation point
2022-05-02T12:58:50.217+00:00

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
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,132 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 59,351 Reputation points Microsoft Employee
    2022-05-04T07:23:24.19+00:00

    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.

    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