Differences Between number of sort buffers and max data buffers per lava sort

There are a number of differences between number of sort buffers and max data buffers per lava sort.

Note: The differences betwen max data buffers per lava sort and number of sort buffers influences the lava operator during optimization. However, the query processor cannot predict the number of available cache buffers at runtime. If the Execute engine cannot find a sufficient number of tempdb single-page cache buffers, it may use system worktable for the sorting or hashing instead.