Microsoft SQL Server

kubernetes opsverse's kubernetes agent https //docs opsverse io/install the opsverse agent#veqxm 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 https //docs opsverse io/install the opsverse agent#veqxm deployment enabled true mssql enabled true config | \ connection string "sqlserver //\<username> \<password>@\<service name> \<namespace> svc cluster local 1433" instance \<unique db server name> 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 https //grafana com/docs/agent/latest/static/configuration/integrations/mssql config/# text=full%20reference%20of%20options%3a standalone vm you can configure the opsverse agent https //docs opsverse io/install the opsverse agent#dszlx 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 https //grafana com/docs/agent/latest/static/configuration/integrations/mssql config/# text=full%20reference%20of%20options%3a