Andreas Wolter • 8/9/2017

Optimizing workflows with In-Memory and Natively Compiled Objects – or how it does not work

This technical article analyzes a common ETL workflow optimization attempt using SQL Server's In-Memory features (memory-optimized tables, TVPs, natively compiled procedures). It details a scenario where replacing a temporary table with a memory-optimized table-valued parameter unexpectedly leads to similar or worse performance due to persistent disk I/O and locking in interop mode, concluding there is no 'quick win'.

0 comments

#SQL Server #Table Valued Parameters #Xtp Engine