We are about to migrate a database from SS2005 32-bit to 2008 64-bit. One of the biggest drivers for this is the compression capability in SS2008. We expect to shrink our 2TB database down to about 500GB (proven in testing), and get the comparable IO performance improvements (4x faster reads - also proven in testing).
Does anyone have any experience with the new row level compression? Any concerns or advise in this move?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!