Skip to content

diagnostic-settings does not on "Dedicated SQL pool" #20056

@SQLDataSide

Description

@SQLDataSide

Hi
I have set the "diagnostic settings" on Synapse workspace and it work perfectly but it doesn't on Synapse Dedicated SQL Pool, please help, The error message is not clear (PowerShell ISE) and misleading.
Some variables are not been displayed


Synapse dedicated SQL pool NOT WORKING

$DiagnosticsName = 'DedicatedSQLPoolDiagnostics'
$ResourceName = 'MyDedicatedSQLPoolName_DSP'
$ResourceType = 'Microsoft.Synapse/workspaces/sqlPools' # Is this right??????????
$Logs = ''
$Logs = $Logs + ' {"category": "SqlRequests" ,"enabled": true,"retentionPolicy": {"days": 10, "enabled": true}}'
$Metrics = ''

$Logs = '[' + $Logs + ']'
$Logs = $Logs.Replace('"', '""')

az monitor diagnostic-settings create --name $DiagnosticsName --resource-group $ResourceGroupName
--resource-type $ResourceType --resource $ResourceName
--storage-account $StorageAccount --logs $Logs
--metrics $Metrics


Synapse workspace works fine

$DiagnosticsName = 'MySynapseDiagnostics'
$ResourceName = 'MySynapseName'
$ResourceType = 'Microsoft.Synapse/workspaces'
$Logs = ''
$Logs = $Logs + ' {"category": "IntegrationPipelineRuns","enabled": true,"retentionPolicy": {"days": 10, "enabled": true}}'
$Metrics = ''

$Logs = '[' + $Logs + ']'
$Logs = $Logs.Replace('"', '""')

az monitor diagnostic-settings create --name $DiagnosticsName --resource-group $ResourceGroupName
--resource-type $ResourceType --resource $ResourceName
--storage-account $StorageAccount --logs $Logs
--metrics $Metrics

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions