This documentation contains work-in-progress information for future Elastic Stack and Cloud releases. Use the version selector to view supported release docs. It also contains some Elastic Cloud serverless information. Check out our serverless docs for more details.
MSSQL transaction_log metricset
editMSSQL transaction_log metricset
edittransaction_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.
This is a default metricset. If the host module is unconfigured, this metricset is enabled by default.
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",
"event": {
"dataset": "mssql.transaction_log",
"duration": 115000,
"module": "mssql"
},
"metricset": {
"name": "transaction_log",
"period": 10000
},
"mssql": {
"database": {
"id": 1,
"name": "master"
},
"transaction_log": {
"space_usage": {
"since_last_backup": {
"bytes": 937984
},
"total": {
"bytes": 2088960
},
"used": {
"bytes": 1318912,
"pct": 63.13725662231445
}
},
"stats": {
"active_size": {
"bytes": 937983.737856
},
"backup_time": "1900-01-01T00:00:00Z",
"recovery_size": {
"bytes": 0.894531
},
"since_last_checkpoint": {
"bytes": 937983.737856
},
"total_size": {
"bytes": 2088959.475712
}
}
}
},
"service": {
"address": "172.23.0.2:1433",
"type": "mssql"
}
}