SQL Server 2008 页/行压缩的想法
这里的其他人是否玩过 SQL Server 2008 Compression 在其数据集的页面或行级别上有多少？ 您对速度和磁盘空间方面的性能印象如何？
有人见过压缩明显损害性能吗？
在一些巨大的事实表上，我们一直在研究并注意到压缩可以对表及其索引产生非常有益的查询速度差异。 它还节省了大量磁盘空间（某些数据约为 50%）。 我们的硬件设置相对于处理器而言受到严格的磁盘/IO 限制，到目前为止，压缩对我们来说似乎是一个非常简单的性能胜利。
Have other people here played with SQL Server 2008 Compression at either the page or the row level on their datasets much? What have your impressions been on performance both speed and disk-space wise?
Has anyone ever seen compression demonstrably hurt performance?
On some of our huge fact tables we've been playing around and noticing that compression can make a hugely beneficial query speed difference on both tables and its indexes. It's also been saving a lot of disk space (~50% on some data). Our hardware setup is severely disk/io bound relative to the processor and compression so far seems like a trivially easy performance win for us.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
老问题，但根据经验，一个简单的经验法则是：
Linchi Shea 文章似乎现在需要登录......
Linchi Shea 发布了一些关于此主题的有趣文章：
SQL Server 2008 页面压缩：与实际情况的压缩比数据库
SQL Server 2008 数据压缩：数据分布的影响
SQL Server 2008 页面压缩：对表扫描的性能影响
SQL Server 2008 页面压缩：对插入的性能影响
SQL Server 2008 页面压缩：使用多个处理器
这可能也令人感兴趣：
SQL Server 存储引擎博客 也有一些关于压缩的有趣帖子。
Old question, but from experience, a simple rule of thumb is:
Linchi Shea articles seem to be behind a login now....
Linchi Shea has posted some interesting articles on this topic:
SQL Server 2008 Page Compression: Compression ratios with real-world databases
SQL Server 2008 Data Compression: Impact of Data Distribution
SQL Server 2008 Page Compression: Performance impact on table scans
SQL Server 2008 Page Compression: Performance impact on inserts
SQL Server 2008 Page Compression: Using multiple processors
This might also be of interest:
The SQL Server Storage Engine blog also has a few interesting posts on Compression.