The MSSQL_TransactionLog class represents the transaction log of a Microsoft SQL Server database. A SQL Server transaction log maintains a record of modifications to the operating system files containing the data of an SQL Server database. The transaction log provides data recovery assistance if a system failure occurs, and a SQL Server database has at least one operating system file that stores transaction log records. A transaction log can be written to more than one operating system file. Each SQL Server database maintains its own transaction log, and the operating system file or files that store log records cannot be shared with another database.
Default Collection Interval — Every 30 minutes
Table 1-57 MSSQL Transaction Log Metrics
| Metric | Description |
|---|---|
|
Database Name (key column) |
FileGroup name. |
|
Size |
Initial size of the database. |
|
Last Backup |
Time of the last backup. |
|
Auto-growth Potential Space (MB) |
Amount of disk space available for the log to grow into based on its autogrowth settings. |
|
Transaction Log Space Available (%) |
Percentage of space available in the database. |
|
Unused Space (MB) |
Unused space in the database. |