9

I'm curious as to how SQL Server's buffer pool is affected by compressed data tables.

Is the data in memory compressed, just as it is on disk, or is it fully decompressed?

If the data is stored compressed in the buffer pool, how much of the transient decompressed data is held in memory at a given time when executing a statement; a row/page, the entire table (assuming there is sufficient free pages to hold the data), or "it depends"?

asked Sep 8, 2011 at 4:37

1 Answer 1

8

When data is in the buffer pool it is compressed. The data within the row/column needs to be decompressed when the row/column is read. The storage engine team (the guys that wrote this stuff) did a blog post about this which has some good info in it. (Yes I stole the above line from the blog post.)

Glorfindel
2,2095 gold badges19 silver badges26 bronze badges
answered Sep 8, 2011 at 5:14
0

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.