SQL Server Example .yaml

custom_metrics:
    
    - name: sqlserver.buffer.page_lookups
      counter_name: Page lookups/sec

    - name: sqlserver.buffer.page_reads
      counter_name: Page reads/sec

    - name: sqlserver.workload.queued_requests
      counter_name: Queued Requests
      instance_name: internal

    - name: sqlserver.databases.log_flushes
      counter_name: Log Flushes/sec
      instance_name: ALL
      tag_by: db

    - name: sqlserver.index_searches
      counter_name: Index Searches/sec
    
    - name: sqlserver.db.commit_table_entries
      counter_name: Commit table entries
      instance_name: ALL
      tag_by: db
    
    - name: sqlserver.db.tracked_transactions_per_sec
      counter_name: Tracked transactions/sec
      instance_name: ALL
      tag_by: db
          
    - name: sqlserver.db.transactions_per_sec
      counter_name: Transactions/sec
      instance_name: ALL
      tag_by: db
      
    - name: sqlserver.db.batch_requests_per_sec
      counter_name: Batch Requests/sec
      instance_name: ALL
      tag_by: db
     
    - name: sqlserver.db.log_file_size
      counter_name: Log File(s) Size (KB)
      instance_name: ALL
      object_name: MSSQL$SQLEXPRESS:Databases
      tag_by: db
      
    - name: sqlserver.db.data_file_size
      counter_name: Data File(s) Size (KB)
      instance_name: ALL
      object_name: MSSQL$SQLEXPRESS:Databases
      tag_by: db
      
    - name: sqlserver.db.log_file_used_size
      counter_name: Log File(s) Used Size (KB)
      instance_name: ALL
      object_name: MSSQL$SQLEXPRESS:Databases
      tag_by: db

    - name: sqlserver.db.sizetest
      table: sys.database_files
      counter_name: database_files
      columns:
        - size
      tag_by: db
      
    - name: sqlserver.LCK_M_S
      table: sys.dm_os_wait_stats
      counter_name: LCK_M_S
      columns:
        - max_wait_time_ms
        - signal_wait_time_ms
      tag_by: db