Improves OLTP performance up to 24 times, and DW up to 22 times

Provided by: Microsoft
Topic: Big Data
Format: HTML
Samsung Electro-Mechanics found a new solution that would leverage the SPC (Statistical Process Control) system. For the SPC system handling a large number of items, it has to process high volumes of transactions. The authors were especially impressed that SQL Server 2014 OLTP In-Memory is not only latch free, but also lock free and thus guarantees data consistency. OLTP speed improved up to 24 times when they built the native code using In-Memory complier. Even the slow retrieval system became 22 times faster in its processing speed when CCI (Clustered Columnstore Indexes) was applied.

Find By Topic