You are here: System database > mtransactionlog
   |
   |
|
mtransactionlog
|
|
|
|
The dynamic mtransactionlog table provides information on the transaction log file of each server instance.
Table Columns
|
Name |
Type |
Description |
|
instance_id |
INTEGER |
Server instance. References sysinstances (id) |
|
log_bytes_sec |
INTEGER |
Current rate of bytes being sent to the log manager per second |
|
disk_sec |
INTEGER |
Current rate of disk write operations to transaction log per second |
|
commit_sec |
INTEGER |
Current rate of commit/rollback requests recieved per second. disk_sec may be lower than commit_sec, if there are group-commits happening. A group-commit is when the process waits for other commits before writing to disk, for efficiency. |
|
file_size |
INTEGER |
Current size of transaction log file in MB |
Related