MSSQL transaction_log metricset

edit

MSSQL transaction_log metricset

edit

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.

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

  • space_usage.since_last_backup.bytes: The amount of space used since the last log backup in bytes
  • space_usage.total.bytes: The size of the log in bytes
  • space_usage.used.bytes: The occupied size of the log in bytes
  • space_usage.used.pct: A percentage of the occupied size of the log as a percent of the total log size
  • stats.active_size.bytes: Total active transaction log size in bytes
  • stats.backup_time: Last transaction log backup time.
  • stats.recovery_size.bytes: Log size in bytes since log recovery log sequence number (LSN).
  • stats.since_last_checkpoint.bytes: Log size in bytes since last checkpoint log sequence number (LSN).
  • stats.total_size.bytes: Total transaction log size in bytes.

Fields

edit

For a description of each field in the metricset, see the exported fields section.

Here is an example document generated by this metricset:

{
    "@timestamp": "2017-10-12T08:05:34.853Z",
    "agent": {
        "hostname": "host.example.com",
        "name": "host.example.com"
    },
    "event": {
        "dataset": "mssql.transaction_log",
        "duration": 115000,
        "module": "mssql"
    },
    "metricset": {
        "name": "transaction_log"
    },
    "mssql": {
        "database": {
            "id": 1,
            "name": "master"
        },
        "transaction_log": {
            "space_usage": {
                "since_last_backup": {
                    "bytes": 135168
                },
                "total": {
                    "bytes": 2088960
                },
                "used": {
                    "bytes": 622592,
                    "pct": 29.80392074584961
                }
            },
            "stats": {
                "active_size": {
                    "bytes": 135167.737856
                },
                "backup_time": "1900-01-01T00:00:00Z",
                "recovery_size": {
                    "bytes": 0.128906
                },
                "since_last_checkpoint": {
                    "bytes": 135167.737856
                },
                "total_size": {
                    "bytes": 2088959.475712
                }
            }
        }
    },
    "service": {
        "address": "172.26.0.2",
        "type": "mssql"
    }
}