Upgrading to SQL Server 2008 for Better Performance

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. 

Latest Articles