MSSQL moduleedit

Warning

This functionality is in beta and is subject to change. The design and code is less mature than official GA features and is being provided as-is with no warranties. Beta features are not subject to the support SLA of official GA features.

This is the Microsoft SQL 2017 Metricbeat module. It is still in beta and under active development to add new Metricsets and introduce enhancements.

Compatibilityedit

The module is being tested with 2017 GA version under Linux

Metricsetsedit

The following Metricsets are already included:

transaction_logedit

transaction_log Metricset fetches information about the operation and transaction log of each MSSQL database in the monitored instance. All data is extracted from the Database Dynamic Management Views

performanceedit

performance Metricset fetches information from what’s commonly known as Performance Counters in MSSQL.

Example configurationedit

The MSSQL module supports the standard configuration options that are described in Specify which modules to run. Here is an example configuration:

metricbeat.modules:
- module: mssql
  metricsets:
    - "transaction_log"
    - "performance"
  hosts: ["sqlserver://sa@localhost"]
  period: 10s

Metricsetsedit

The following metricsets are available: