IMPORTANT: No additional bug fixes or documentation updates
will be released for this version. For the latest information, see the
current release documentation.
mssql transaction_log metricset
editmssql transaction_log metricset
editThis functionality is in technical preview and may be changed or removed in a future release. Elastic will work to fix any issues, but features in technical preview 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
editFor 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" } }