“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, non aggregate variable assignment results.
“Work Table Merge Locks”–reports contention for locks while results from work tables were being merge.
“Total # of Requests” prints the total of the three types of merge requests.