The story effectively builds tension around a classic "will they, won't they" scenario and culminates in a physical encounter where lines of consent and intent are blurred.
SELECT execution_id, package_name, task_name, max_buffer_size_kb, avg_buffer_size_kb, max_rows_per_buffer, avg_rows_per_buffer FROM catalog.adaptive_buffer_stats WHERE max_buffer_size_kb = (SELECT MAX(MaxBufferSizeKB) FROM catalog.execution_performance); ssis-948