Alternative tool to monitor the SQL requests of a Serverless SQL pool

pmscorca 882 Reputation points
2023-11-27T13:42:56.74+00:00

Hi,

I'd like to know if it exist another tool in order to monitor the SQL requests of a Synapse Serverless SQL pool, apart Synapse Studio.

User's image

Thanks

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,668 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Amira Bedhiafi 19,626 Reputation points
    2023-11-27T19:52:18.6533333+00:00

    You can set up a Log Analytics workspace and connect it with Synapse to send logs of serverless SQL requests. This method allows for a configurable retention period and the use of customized KQL queries for enhanced monitoring of your serverless SQL queries.

    The QPI library is a free, open-source set of T-SQL views that provide valuable information about your queries. This tool can be easily installed and used to monitor query performance in Synapse serverless SQL pools :

    https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/monitoring-synapse-serverless-sql-pool-query-history/ba-p/3710423#:~:text=,com%E3%80%91

    0 comments No comments