Browse by Tags

• Performance
• SQL Server 2008
• Storage

• SQL Server 2008 Page Compression: Performance impact on table scans

  My previous post shows that data compression may not come for free, although hopefully by the RTM time the adverse performance impact on inserts will have been reduced significantly. In this post, I want to show you that data compression can enhance read Read More... Posted Friday, May 16, 2008 10:28 PM by Linchi Shea | 0 Comments Filed under: Performance, SQL Server 2008, Data Compression Attachment(s): table_scan.gif

• SQL Server 2008 Page Compression: Performance impact on inserts

  Before I begin, let me be very clear that the results I report in this post were obtained with SQL Server 2008 CTP6. Microsoft is still working on improving the performance of data compression. And in particular, the performance of inserting into a compressed Read More... Posted Monday, May 12, 2008 11:49 PM by Linchi Shea | 5 Comments Filed under: Performance, SQL Server 2008, Data Compression Attachment(s): data_inserts.gif

• SQL Server 2008 Page Compression: Compression ratios with real-world databases

  In my previous post on data compression, I looked at how rebuilding a table with page compression works with multiple processors via the MAXDOP option. In this post, I'll focus on what compression ratios I have seen in the real-world databases. Now, if Read More... Posted Sunday, May 11, 2008 8:20 PM by Linchi Shea | 10 Comments Filed under: Storage, SQL Server 2008, Data Compression Attachment(s): real_comp.gif

• SQL Server 2008 Page Compression: Using multiple processors

  SQL Server 2008 has introduced a long sought after feature -- Data Compression. This is a great feature, and I have no doubt it'll be widely used. The key compression method is called page compression, which uses the following three techniques to reduce Read More... Posted Monday, May 05, 2008 10:59 AM by Linchi Shea | 7 Comments Filed under: Performance, SQL Server 2008, Data Compression Attachment(s): maxdop.gif