Despite all the performance improvements that have gone into AS SP2, several of my customers reported worse query performance after migrating. Today I saw two new KB articles (frustratingly short on detail) that suggest that these performance problems may have been fixed:
Interesting…
We had major problems going to SP2 due to cell data security being much slower on SP2 than SP1. We eventually did away with our cell data security (used to hide certain fields) and went with a UserSecurity dimension/measure group and SCOPE statements.