Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- init_config:
- #
- # By default, we only capture *some* of the metrics available in the
- # `sys.dm_os_performance_counters` table. You can easily add additional
- # metrics by following the custom_metrics structure shown below.
- #
- # In order to connect to SQL Server either enable SQL Authentication and
- # specify a username or password below. If you do not specify a username
- # or password then we will connect using integrated authentication.
- #
- # custom_metrics:
- # This is a basic custom metric. There is not instance associated with
- # this counter.
- #
- # - name: sqlserver.clr.execution
- # counter_name: CLR Execution
- # This counter has multiple instances associated with it and we're
- # choosing to only fetch the 'Cumulative execution time (ms) per second' instance.
- #
- # - name: sqlserver.exec.in_progress
- # counter_name: OLEDB calls
- # instance_name: Cumulative execution time (ms) per second
- # This counter has multiple instances associated with it and we want
- # every instance available. We'll use the special case ALL instance
- # which *requires* a value for "tag_by". In this case, we'll get metrics
- # tagged as "db:mydb1", "db:mydb2".
- #
- # - name: sqlserver.db.commit_table_entries
- # counter_name: Log Flushes/sec
- # instance_name: ALL
- # tag_by: db
- instances:
- - host: 127.0.0.1,1433
- username: datadog
- password: 9y0kJl4fCF4bn8IlzEmDPayE
- # Optional, timeout in seconds for the connection and each command run
- # command_timeout: 30
- # database: my_database # Optional, defaults to "master"
- tags:
- - optional_tag
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement