Upgrading to SQL Server 2008 for Better Performance

Tuesday Apr 6th 2010 by DatabaseJournal.com Staff

Do you need more justification on why your organization should migrate to SQL Server 2008? This white paper describes some of the new features of SQL Server 2008, and how they can be leveraged to add value to your migration.

Migrating to a new version of SQL Server should not be based on the desire to be on new technology.  Instead, you should base it on business requirements.   Migrations are costly therefore you want to make sure you get some value for the effort you spend migrating your application.   SQL Server 2008 comes with a number of new features.  If you need these new features then migrating to SQL Server 2008, make sense.

There are a number of different features in SQL Server 2008 that you might be able to leverage to identify value for your migration effort.  Here are a few of those features:

·         Data compression

·         Policy based management

·         Improved database mirroring

·         Data collector

·         Resource governor

·         Transparent data encryption

These features can be used to save on disk space, throttle CPU and memory resources, control your different environments consistently, provide a more secure environment for your data, and allow you to monitor and improve performance.

Migrating to SQL Server 2008 is much easier than past migrations.  SQL Server 2008 has been out for quite a while now, so there is no question it is stable.  If you couple stability with other cost savings features, improved management functionality, and performance enhancements then SQL Server 2008 appears to have a number value add features that older releases do not.  By reading this white paper, you will understand more about the new features of SQL Server 2008 that can help your organization and justify the value of migrating to SQL Server 2008. 

Mobile Site | Full Site