Data and Page Compressions – Data Storage and IO Improvement

added by pinaldave
3/8/2010 7:30:00 AM

11 Kicks, 260 Views

The performance of SQL Server is primarily decided by the disk I/O efficiency. Improving I/O definitely improves the performance. SQL Server 2008 introduced Data and Backup compression features to improve the disk I/O. Here, I will explain Data compression. A detail analysis of the performance along with working script.