%1 SortMergePass: Merged %2 runs, %3 Secs, %4 runs remaining, %5 reads=%6 M, runlen=%7, phase %8, %9 M on disk
Item |
Value |
|---|---|
SQLCode |
1009143 |
Constant |
EMSG_SORT_INFOMERGED1 |
SQLState |
QSB40 |
ODBC State |
OK |
Parameter 1 |
what is being sorted |
Parameter 2 |
how many runs were merged in this merge pass |
Parameter 3 |
time taken in this merge pass |
Parameter 4 |
how many runs still to be merged |
Parameter 5 |
how many page reads done in this pass |
Parameter 6 |
how many megabytes (MB) of data read in this pass |
Parameter 7 |
average length of runs in pages for this pass |
Parameter 8 |
fractional phase number reached |
Parameter 9 |
how many megabytes (MB) of data physically read in this pass |
This information is provided after each merge pass. One merge pass merges a certain number of runs, using one pinned buffer page per run, plus one pinned buffer for the output run. Note that there can be several passes in a merge phase. One merge phase reads all the sort data and produces a new set of runs that provide input to the next phase.
