Blog Post

Azure Synapse Analytics Blog

6 MIN READ

Monitoring serverless SQL ended requests by using Log Analytics.

Microsoft

Oct 25, 2022

Scenario Today I would like to share a scenario that I was working on one of my serverless SQL Pool support cases. The customer asked for an advice on how to monitor serverless SQL requests by ...

Updated Oct 26, 2022

Version 2.0

Synapse Monitoring

Synapse SQL

scirqueira

Microsoft

Joined January 27, 2022

View Profile

Azure Synapse Analytics Blog

Follow this blog board to get notified when there's new activity

scirqueira

Microsoft

Oct 09, 2023

Hi pedromatostlw7 I apologize for the delayed response.

As far as I know, unfortunately, there is no way to get the database name from both (log analytics table and DMVs) The query will return only the result from the whole SQL serverless pool.

References: Azure Monitor Logs reference - SynapseBuiltinSqlPoolRequestsEnded | Microsoft Learn
Monitoring Synapse serverless SQL pool query history - Microsoft Community Hub

Thanks for reaching out!