If we all look back, one thing you all will surely notice that CPU power has increased and its getting better and better every year.
If you compare the growth in technology with other components like disk speed ,memory, networking components etc etc, certainly CPU always stands out.
When we talk about SQL Server performance, its not stopped at disk speed, throughput and other individual components but is a mix of everything.
In SQL Server 2008 r2 ,compression is one great way to take away the load from the disk and memory perspective. Its simple, data and backup compression means less space and more data in cache. There is a little trade off in terms of processing the compression but now you have great processing power by intel series 2 sockets processors.
So why not go ahead and try it by yourself and see how much benefit you can get by exploring this feature.
I wont suggest you to go and blindly start compressing everything : ) :) , but start calculating your workload and focus on tables and indexes which are IO intensive and analyze if those objects can be compressed and give you more benefits in terms of IO and memory.
If you compare the growth in technology with other components like disk speed ,memory, networking components etc etc, certainly CPU always stands out.
When we talk about SQL Server performance, its not stopped at disk speed, throughput and other individual components but is a mix of everything.
In SQL Server 2008 r2 ,compression is one great way to take away the load from the disk and memory perspective. Its simple, data and backup compression means less space and more data in cache. There is a little trade off in terms of processing the compression but now you have great processing power by intel series 2 sockets processors.
So why not go ahead and try it by yourself and see how much benefit you can get by exploring this feature.
I wont suggest you to go and blindly start compressing everything : ) :) , but start calculating your workload and focus on tables and indexes which are IO intensive and analyze if those objects can be compressed and give you more benefits in terms of IO and memory.
No comments:
Post a Comment