Example sqlserver.yaml

sqlserver.yaml

collector:
  sqlserver:
    all:
      # Specify instances to monitor with a comma-delimited list of connection strings.
      # All connection parameters are optional.
      # By default, the host is localhost, listening on default port, TCP 1433.
      #   for Windows, the user is the currently running AD user (SSO).
      #   See https://github.com/denisenkom/go-mssqldb for detailed connection
      #   parameters.
      servers: |
        server=localhost;user id=appoptics;password=PLEASECHANGEME;app name=hostagent;log=1;

      ## Optional parameter, setting this to 2 will use a new version
      ## of the collection queries that break compatibility with the original
      ## dashboards.
      query_version: 2

      ## If you are using AzureDB, setting this to true will gather resource utilization metrics
      # azuredb: false

      ## If you would like to exclude some of the metrics queries, list them here
      ## Possible choices:
      ## - PerformanceCounters
      ## - WaitStatsCategorized
      ## - DatabaseIO
      ## - DatabaseProperties
      ## - CPUHistory
      ## - DatabaseSize
      ## - DatabaseStats
      ## - MemoryClerk
      exclude_query: |
        VolumeSpace


load:
  plugin: snap-plugin-collector-bridge-sqlserver
  task: task-bridge-sqlserver.yaml