Microsoft SQL Server
OpsVerse'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.
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
You can configure the OpsVerse 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:
Add the MSSQL YAML snippet given below to /etc/opsverse/agent-config.yaml and then restart the service using:
You can further append configurations for MSSQL as per your requirements following this documentation