We compressed a cube for the first time on 4/16. I was very pleased that we compressed the data about 37% from 8.9 million rows to 5.6. I expected response time to improve.
I hear today that performance was very poor last week. I used ST03N to compare the week before to the week after compression. There is definitely a decline in query performance and it is specifically the database time that declined.
Though I'm not positive that the compression had anything to do with the poor response time, I can't think of any other activity that occurred doing this time frame. Has anybody ever run into a scenario where response time degrades after compression? Any idea of what I can look at to get my hands around this?
Thanks,
Chris