%1 SortMergeDone: Ave mem %2 M, %3 Secs, %4 passes, %5 reads, %6 M data=%7 pgs, %8 phases, %9 M on disk
Item |
Value |
|---|---|
SQLCode |
1009144 |
Constant |
EMSG_SORT_INFOMERGED2 |
SQLState |
QSB41 |
ODBC State |
OK |
Parameter 1 |
what is being sorted |
Parameter 2 |
time-average number of pinned page buffers used by Phase II of the sort |
Parameter 3 |
time taken for Phase II of the sort |
Parameter 4 |
total number of passes in Phase II |
Parameter 5 |
total number of page reads in Phase II |
Parameter 6 |
total megabytes (MB) of data sorted |
Parameter 7 |
total number of pages of data sorted |
Parameter 8 |
number of merge phases in the merge sort of Phase II |
Parameter 9 |
total megabytes (MB) of physical reads in Phase II |
This information is provided at the end of Phase II to summarize the resource usage of the whole merge sort. The last pass of the sort is separately reported in an EMSG_SORT_INFOMERGED1 message.
