monOpenDatabases

The monOpenDatabases Monitoring and Diagnostic (MDA) table, which provides state and statistical information pertaining to databases that are currently in use, has these new columns:

Column name	Datatype	Description
LastCheckpointTime	datetime	The date and time that the last checkpoint started for the database. If no checkpoint occurs, the value is NULL.
LastTranLogDumpTime	datetime	The date and time that the last dump transaction started for the database.If: There is no dump transaction, the value is NULL. The transaction is dumped using the truncate_only or no_log clause, the time is not updated.

Column name

Datatype

Description

LastCheckpointTime

datetime

The date and time that the last checkpoint started for the database.

If no checkpoint occurs, the value is NULL.

LastTranLogDumpTime

datetime

The date and time that the last dump transaction started for the database.If:

There is no dump transaction, the value is NULL.
The transaction is dumped using the truncate_only or no_log clause, the time is not updated.

The original BackupStartTime column is updated only when a database is dumped.