With most databases, there is often a great deal of scope available for reducing the overall size and I’ve discussed earlier why doing this is so important.

For this particular customer database, applying the following changes:

  • Balanced approach of ROW and PAGE compression
  • Compressed large string data
  • Reduced PDF image sizes

took the database from 3.8TB total to 550GB of data. That’s a big outcome for the client. 

The final (almost unexpected) benefit was that the database now almost fitted entirely in memory. (The customer system had 512GB of main memory). You can imagine how that improved the overall performance and manageability.

Next time, we’ll be back to another interesting case that came up during my consulting work.