Now that our transition to brand new systems and platforms has finished I want to share with you a few warnings.
The first one is about report subscriptions, an issue I dedicated a post to.
The second one is a generic one about the differences you’ll going to find in the SQL optimizer. Simply put you should review any custom report you developed and be ready to change your queries if execution time jumps up. I had a report that used to run in under 5’ on SQL 2008, once moved to SQL 2008 R2 it timed out after 30’ loading the CPU heavily during that time.
I didn’t notice issues in the standard reports we’re using (actually a subset of those provided), but we’ve had a similar SQL anomalous usage caused by the exchange 2010 MP, I cannot say if we would have had the same pattern on 2008.
So be warned changing the SQL platform is something that must be planned.
This posting is provided “AS IS” with no warranties, and confers no