Metricbeat service starts then stop when trying to use the MSSQL

Elastic Stack Beats
1

I'm trying to log some metrics from Microsoft MSSQL and the Metricbeat service starts then stop. I'm thinking that I have something wrong in the mssql.yaml file that is causing this. Windows errors logs have not been much help. Has anyone seen this before?local mssql info

7_9_2020_error
7_9_2020_error1152×648 20.7 KB

2

yaml file looks like this:

Module: mssql

Docs: https://www.elastic.co/guide/en/beats/metricbeat/7.8/metricbeat-module-mssql.html

  • module: mssql
    metricsets:
    • "transaction_log"
    • "performance"
      hosts: ["TSFARM-DATA\SQL2016"]
      username: sa
      password: verysecurepassword
      period: 10s
3

Hi!

The indentation in the configuration you posted is wrong? Could you verify that the failure you see is not because of this?

Also I would suggest tuning the logging settings (https://www.elastic.co/guide/en/beats/metricbeat/current/configuration-logging.html) and look into the logs for the specific error.

C.

4

I was able to get the service started now. Thank you for that. However I still don't seem to be getting SQL metrics. Any idea?

5

here is the yaml after correction:

Module: mssql

Docs: https://www.elastic.co/guide/en/beats/metricbeat/7.8/metricbeat-module-mssql.html

? "-module"
: mssql
? "hosts:TSFARM-DATA\SQL2016"
: ~
metricsets: ~
? "password:"
: ~
performance: ~
period: 10s
tansaction_log: ~
? "username:sa"
: ~

6

Hi!

I suggest you should check in the logs for errors since may things can go wrong. Run Metribceat in debug mode and check if there is any related error.

You can find more about logging at https://www.elastic.co/guide/en/beats/metricbeat/current/configuration-logging.html

7

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.