Monitor MSSQL DataBase using Splunk Cloud Observability Monitoring tool
Basic settings for the Splunk OpenTelemetry Collector
extensions:
health_check:
endpoint: "0.0.0.0:13133"
smartagent:
bundleDir: "C:\\Program Files\\Splunk\\OpenTelemetry Collector\\agent-bundle"
collectd:
configDir: "C:\\Program Files\\Splunk\\OpenTelemetry Collector\\agent-bundle\\run\\collectd"
receivers:
smartagent/sqlserver:
type: telegraf/sqlserver
host: "EC2AMAZ-8OVL87O" # Replace with your EC2 instance hostname if different
port: 1433
userID: "" # Leave this empty for Windows authentication
password: "" # Leave this empty for Windows authentication
appName: "otel-collector" # Optional: app name for SQL Server connection
queryVersion: 2 # Default query version used by the SQL Server monitor
hostmetrics:
collection_interval: 60s
scrapers:
cpu:
memory:
disk:
filesystem:
network:
processes: # This scraper collects process-related metrics
processors:
batch:
resourcedetection:
detectors: [system]
exporters:
signalfx:
access_token: "g3G71sMmqTUkjPoFmRh0kwww" # Replace with your actual Splunk access token
realm: "us1"
ingest_url: "https://ingest.us1.signalfx.com"
api_url: "https://api.us1.signalfx.com"
trace_url: "https://ingest.us1.signalfx.com/v2/trace"
hec_url: "https://ingest.us1.signalfx.com/v1/log"
service:
pipelines:
metrics:
receivers: [smartagent/sqlserver, hostmetrics]
processors: [batch, resourcedetection]
exporters: [signalfx]
telemetry:
metrics:
address: "0.0.0.0:8888" # Telemetry endpoint
logs:
level: "DEBUG" # Set the log level to DEBUG for more detailed logs
extensions: [health_check, smartagent]