log diagnostics Azure SQL

diagnostics-metrics-azure-sql.json

{
  "type": "providers/diagnosticSettings",
  "name": "Microsoft.Insights/diagnostic_primary",
  "dependsOn": [
    "[resourceId('Microsoft.Sql/servers/databases', variables('primarySqlServerName'), parameters('databaseName'))]"
  ],
  "apiVersion": "2017-05-01-preview",
  "properties": {
    "name": "Diagnostic_test",
    "storageAccountId": "[resourceId('Microsoft.Storage/storageAccounts', variables('storageAccountNamePrimary'))]",
    "logs": [
      {
        "category": "Blocks",
        "enabled": true,
        "retentionPolicy": {
          "days": 10,
          "enabled": false
        }
      },
      {
        "category": "QueryStoreWaitStatistics",
        "enabled": true,
        "retentionPolicy": {
          "days": 10,
          "enabled": false
        }
      },
      {
        "category": "Errors",
        "enabled": true,
        "retentionPolicy": {
          "days": 10,
          "enabled": false
        }
      },
      {
        "category": "QueryStoreRuntimeStatistics",
        "enabled": true,
        "retentionPolicy": {
          "days": 10,
          "enabled": false
        }
      },
      {
        "category": "DatabaseWaitStatistics",
        "enabled": true,
        "retentionPolicy": {
          "days": 10,
          "enabled": false
        }
      },
      {
        "category": "Timeouts",
        "enabled": true,
        "retentionPolicy": {
          "days": 10,
          "enabled": false
        }
      },
      {
        "category": "SQLInsights",
        "enabled": true,
        "retentionPolicy": {
          "days": 10,
          "enabled": false
        }
      },
      {
        "category": "Audit",
        "enabled": true,
        "retentionPolicy": {
          "days": 10,
          "enabled": false
        }
      },
      {
        "category": "SQLSecurityAuditEvents",
        "enabled": true,
        "retentionPolicy": {
          "days": 10,
          "enabled": false
        }
      }
    ],
    "metrics": [
      {
        "category": "AllMetrics",
        "enabled": true,
        "retentionPolicy": {
          "enabled": false,
          "days": 0
        }
      }
    ]
  }
}