“Merge Lock Requests” reports the number of parallel merge lock requests that were made, how many were granted immediately, and how many had to wait for each type of merge. The three merge types are:
“Network Buffer Merge Locks”– reports contention for the network buffers that return results to clients.
“Result Buffer Merge Locks”– reports contention for the result buffers used to process results for ungrouped aggregates and nonsorted, nonaggregate variable assignment results.
“Work Table Merge Locks”– reports contention for locks while results from worktables were being merged.
“Total # of Requests” prints the total of the three types of merge requests.
