Synapse Serverless Database DMV

Dondapati, Navin 281 Reputation points
2021-08-27T16:37:02.033+00:00

Hi Guys,

Do we have any DMV, which can provide, top bad queries, number of user login, Actively running queries etc for Synapse SQL server less pool?

Which would be handy for troubleshooting, bad performing queries or whether we need data pruning of files or further splitting of files etc.

Regards,
Navin

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.
4,557 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 82,671 Reputation points Microsoft Employee
    2021-08-30T08:40:44.003+00:00

    Hello @Anonymous ,

    Thanks for the question and using MS Q&A platform.

    Synapse serverless SQL pool supports SQL Server catalog views only.

    For more details, refer System views supported in Synapse SQL.

    You can view the actively running/ended queries for Synapse SQL serverless pool from the monitoring tab.

    127571-image.png

    This article1 and atricle2 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.

    From Azure Portal => Monitoring Tab => Metrics you can monitor (data processed, Number of login attempts, Number of ended SQL requests).

    127537-image.png

    For more details, refer to Use Azure Monitor with your Azure Synapse Analytics workspace

    Hope this helps. Do let us know if you any further queries.

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

    Please "Accept the answer" if the information helped you. This will help us and others in the community as well.


0 additional answers

Sort by: Most helpful