showrecovery [(dbid | dbname)]
Show recovery diagnostics for database <dbid>/<dbname>.
1> dbcc showrecovery
2> go
Recovery Log Markers:
Checkpoint Log Record: (521145198, 21)
First Log Record: (516510375, 14)
Last Log Record: (521145198, 21)
Analysis Statistics:
Log I/O Size: 32768
Total records to scan: 149658428
Number of records in phase 1: 0 (0.0%)
Number of records to redo in phase 1: 3 (100.0%)
Number of records in phase 2: 149658428 (100.0%)
Number of records to redo in phase 2: 149658428 (100.0%)
Total number of log records to redo: 149658431 (100.0%)
Redo Statistics:
Total operations considered for redo: 5
Operations that did not need redo (PFTS check): 3 (60.0%)
Operations that might need redo (PFTS check): 0 (0.0%)
Operations that needed redo (timestamp check): 0 (0.0%)
Operations that did not need redo (timestamp check): 2 (40.0%)
Total number of log records to undo: 4