SQl Server

Filters

  • Standard Value Filter (see Generic Filters)
  • ARM Resource Filters (see Generic Filters)
    • Metric Filter - Filter on metrics from Azure Monitor - (see SQL Server Supported Metrics)
    • Tag Filter - Filter on tag presence and/or values
    • Marked-For-Op Filter - Filter on tag that indicates a scheduled operation for a resource

Actions

Example Policies

This set of policies will mark all SQL servers for deletion in 7 days that have ‘test’ in name (ignore case), and then perform the delete operation on those ready for deletion.

policies:
  - name: mark-test-sql-servers-for-deletion
    resource: azure.sqlserver
    filters:
      - type: value
        key: name
        op: in
        value_type: normalize
        value: test
     actions:
      - type: mark-for-op
        op: delete
        days: 7
  - name: delete-test-sqlservers
    resource: azure.sqlserver
    filters:
      - type: marked-for-op
        op: delete
    actions:
      - type: delete

This policy will find all SQL servers with average DTU consumption under 10 percent over the last 72 hours and notify user@domain.com

policies:
  - name: notify-sqlserver-under-utilized
    resource: azure.sqlserver
    filters:
      - type: metric
        metric: dtu_consumption_percent
        op: lt
        aggregation: average
        threshold: 10
        timeframe: 72
     actions:
      - type: notify
        template: default
        priority_header: 2
        subject: Under-utilized SQL Server
        to:
          - user@domain.com
        transport:
          - type: asq
            queue: https://accountname.queue.core.windows.net/queuename