• David Walker-278941 (4/22/2010)


    sknox (4/22/2010)


    This is also why (I believe) the compression results in faster backup and access times -- the bottleneck in this particular test is the disk array.

    I think that with a lot of SQL Server work, the disk subsystem is the bottleneck... not just in these tests.

    Certainly, but as that's not always the case, and especially as encryption and compression have historically been compute-intensive tasks, I felt it was important to note that fact. As the disk subsystem is the bottleneck here, compression helps performance by decreasing reliance on that subsystem. But if you know that your disk subsystem has better performance characteristics -- or that your CPU has worse -- you should expect less dramatic results -- possibly even decreased performance in extreme cases.