I can't get diagnostics logging working on a dedicated sql pool

Question

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?

Answer 1

@Ellen Heijmans

It sounds like you've diligently checked the common causes. Since you're not seeing any logs at all, even after waiting and confirming the setup, here are a few additional points to consider and test:

Resource Provider Registration - This is often overlooked. Ensure the Microsoft.Synapse resource provider is registered in your Azure subscription. You can check this in the Azure portal by going to Subscriptions -> Your Subscription -> Resource providers. Search for Microsoft.Synapse. If the status is NotRegistered, click Register. This is crucial for proper integration.

Do the same for Microsoft.OperationalInsights (needed for Log Analytics).

Log Analytics Workspace Location - While it's good practice to keep resources in the same region, double-check that the Log Analytics workspace is in a region that supports diagnostic logging for Synapse Dedicated SQL Pools. Although rare, regional limitations can exist.

Diagnostic Setting Scope - Confirm that the diagnostic setting is applied at the correct scope. It should be applied to the dedicated SQL pool resource itself, not the Synapse workspace or a higher-level resource group.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Thank you.

Answer 2

Hi Chandra. One of the things you mentioned was about time delay. That I have to check. But since I have to remove everything at the end of the day otherwise my 100,00 free Azure are gone in notime, I still have to try this out.

Permissions - I've created the workspace and the SQL Pool. So I permissions to read the log should be in place.

Diagnostic Settings - in my screenshots you can see that I've done this.

Querying Logs - That's the problem: there aren't any.

Log Analytics Workspace - Did that.