Just to clarify, the 20% increase is compared to the same cached query of the non-compressed database.

Times:

non-compressed first run 2 minutes, second run 11 seconds

compressed first run 1 minute, second run 14 seconds

I run dbcc freeproccache and dbcc dropcleanbuffers before each first run. The above times are consistantly recreated.

I have seen other queries with similar results for the cached runs. Keep in mind my testing has not been extensive and has only been with a handfull of queries that have been poor performers. We have to give our demo server back to hp, so today will be my last day of testing. We will be setting up a permanant test server in the next few weeks, so we will be able to resume further testing. Steve, if there are any stats such as statistics io you want now, I can send them to you. We do have Microsoft dedicate support engineer we can bring in as well once we get our permanent test server up.