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.
5,135 questions
I can't get diagnostics logging working on a dedicated sql pool
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 91%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEH%3C/text%3E%3C/svg%3E)
Ellen Heijmans
1
Reputation point
I want to see the exec requests and waits on a dedicated pool.
So I created a log analytics workspace in the same workspace as the sql pool and I went to the dedicated sql pool and in the Diagnostics Settings option I created a new one for the logs exec requests and waits.
Then I connected to the database by using SSMS and ran a few queries.
But I can nowhere find the results. I don't see tables under Logs in the Log Analytics Workspace. I don't see them in the logs of the Synapse Workspace. There aren't any tables under the option Logs of the dedicated SQL Pool. And when I go to the Synapse Studio and look under Monitor to SQL Requests, that is empty too.
What am I doing wrong?
{count} votes
-
Nandan Hegde 33,326 Reputation points MVP2025-01-15T08:42:14.67+00:00 Can you provide images of diagnostic settings?
-
Ellen Heijmans 1 Reputation point
2025-01-15T09:07:50.6866667+00:00 -
Ellen Heijmans 1 Reputation point
2025-01-15T09:08:06.21+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla 6,780 Reputation points Microsoft Vendor2025-01-17T04:51:09.49+00:00 Apologies for delay in response.
Greetings & Welcome to Microsoft Q&A forum! Thanks for posting your query!
It sounds like you have set up the diagnostics logging correctly, but there are a few things to check to ensure that you can see the logs for exec requests and waits in your Log Analytics workspace.
Diagnostic Settings - Make sure that you have selected the correct categories for logging in the Diagnostic Settings. You should ensure that both "ExecRequests" and "Waits" are enabled.
Time Delay - After you configure the diagnostic settings and run queries, it might take some time (up to 15 minutes) for the logs to appear in the Log Analytics workspace. If you just set it up, you may need to wait a bit longer.
Log Analytics Workspace - Confirm that the Log Analytics workspace you created is indeed linked to the dedicated SQL pool you are monitoring. Sometimes, if you create multiple workspaces, it can be easy to mistakenly check the wrong one.
Querying Logs - When you navigate to the Log Analytics workspace, ensure you are using the correct Kusto Query Language (KQL) queries to retrieve the logs. For example, you can use:
AzureDiagnostics | where Category contains "ExecRequests"Permissions - Ensure that you have the necessary permissions to view the logs in the Log Analytics workspace.
For more details, please refer the following Microsoft documentations that might help you:
I hope this information helps. Please do let us know if you have any further queries.
Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.
Thank you.
-
Chandra Boorla 6,780 Reputation points Microsoft Vendor
2025-01-17T19:42:28.5133333+00:00 We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer