Skip to main content
2 min read

Microsoft SQL Server

Microsoft SQL Server

Kubernetes​

StackGen's Kubernetes agent can be used to collect metrics from MS SQL Server.

Add the following YAML snippet to the agent's values.yaml and run the agent based on these instructions.

deployment: 
  enabled: true

mssql: 
  enabled: true
  config: |
    - connection_string: "sqlserver://<USERNAME>:<PASSWORD>@<SERVICE_NAME>.<NAMESPACE>.svc.cluster.local:1433" 
      instance: <unique-db-server-name>
info

If you have one or multiple Microsoft SQL Servers that you want to integrate, make sure to add them as a list in the mssql.config inside the agent as shown above

You can further append configurations for MSSQL in the config section as per your requirements following this documentation

Standalone VM​

You can configure the StackGen agent on a single machine to collect metrics from your MSSQL Server(Microsoft SQL Server).

Prerequisite(s):

  • Required MSSQL Grants - It is recommended that you have a dedicated user set up for monitoring an mssql instance. The user for monitoring must have the following grants in order to populate the metrics:
GRANT VIEW ANY DEFINITION TO <MONITOR_USER>
GRANT VIEW SERVER STATE TO <MONITOR_USER>

Add the MSSQL YAML snippet given below to /etc/opsverse/agent-config.yaml and then restart the service using:

sudo systemctl restart opsverse-agent

# add this integrations and configure `mssql` as given below to enable MSSQL integration
integrations:
  mssql:
    enabled: true
    connection_string: "sqlserver://<USERNAME>:<PASSWORD>@<HOST>:<PORT>"
    instance: "<unique-db-server-name>"

You can further append configurations for MSSQL as per your requirements following this documentation

Last updated on