patternsqlMinor
Data compression with in memory OLTP
Viewed 0 times
withcompressionmemoryoltpdata
Problem
Will having
If yes I assume the CPU workload will increase.
data compression enabled decrease the amount of memory used by an in memory OLTP table? If yes I assume the CPU workload will increase.
Solution
Looking at the
But yes, compression uses more CPU. Our experience is that query elapsed times are still shorter because the extra compute time is more than compensated for by the reduced IO latency.
Update: in memory tables now support columnstore indexes which employ compression.
CREATE TABLE definition for 2014 and scrolling down to the box headed "--Memory optimized CREATE TABLE Syntax", there is no mention of compression. Ergo, compression is not available for in-memory tables.But yes, compression uses more CPU. Our experience is that query elapsed times are still shorter because the extra compute time is more than compensated for by the reduced IO latency.
Update: in memory tables now support columnstore indexes which employ compression.
Context
StackExchange Database Administrators Q#64975, answer score: 6
Revisions (0)
No revisions yet.