3

Will having data compression enabled decrease the amount of memory used by an in memory OLTP table?

If yes I assume the CPU workload will increase.

1 Answer 1

6

Looking at the 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.