Things you must consider before upgrading to SQL 2008 R2


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.

– Daniele

This posting is provided “AS IS” with no warranties, and confers no
rights.

Advertisements
  1. Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: