Reports forward and backward scans by lock scheme:
Ascending Scans – reports the number of forward scans on allpages-locked tables.
DOL Ascending Scans – reports the number of forward scans on data-only-locked tables.
Descending Scans – reports the number of backward scans on allpages-locked tables.
DOL Descending Scans – reports the number of backward scans on data-only-locked tables.
For more information on forward and backward scans, see “Indexes” in Performance and Tuning Series: Locking and Concurrency Control.
