Advantages On Upgrading to SQL 2008 - Specific to my environment

Question

Advantages On Upgrading to SQL 2008 - Specific to my environment

curious_sqldba

SSC-Dedicated

Points: 36494
More actions
September 29, 2010 at 11:00 am

#227215

We are planning to upgrade to 2008 from 2005. I have read few articles on the new features. Mentioned below are the areas i am interested to see in the improvement. I would like to know views of others if the mentioned below were solved upgrading to 2008 and we are looking only for Standard edition.
i) Performance- how exactly would upgrading to sql 2008 help in improving the performance.
ii) Backup file - compressing the backup file is this available in 2008 std edition? Will it have any impact on CPU? Would it be a good replacement for LiteSpeed?
iii) BI Suite- How is this improved in 2008?
iv) Peformance data collector - can this be a good replacement for other third party tools like IDera?
Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

UMG Developer SSChampion Points: 13482 More actions · Answer 1

iqtedar (9/29/2010)
i) Performance- how exactly would upgrading to sql 2008 help in improving the performance.

I don't have a list of improvements, but I have seen a number myself. 2008 R2 has even more. Some things I can remember off the top of my head:

* Reduced logging when inserting into an empty table. (Gets most of the benefits of using SELECT ... INTO without the bad locking/blocking issues.)

* Improvements in the hash match algorithm to be slight faster by using less space and having fewer collisions. (At least that is what I remember.)

ii) Backup file - compressing the backup file is this available in 2008 std edition? Will it have any impact on CPU? Would it be a good replacement for LiteSpeed?

My understanding is the SQL Server 2008 Standard edition does not include backup compression.

However SQL Server 2008 R2 Standard edition does. Yes it would have an impact on the CPU usage, but not usually very much. I think it is a good replacement for LiteSpeed, but it might not have all the features, and I don't think it gets as high of a compression ratio.

456789psw SSCarpal Tunnel Points: 4728 More actions · Answer 2

Peformance data collector - can this be a good replacement for other third party tools like IDera --- is nothing close to any of the third party vendors....needs more improvement in many ways. I have been using it for a few weeks now.

1. it will put about a 4% load on the cpu if you can live with that then its better then nothing nice to have a little histroy( it is a start but still needs lots of improvements)...they have discontinued performance dashboard. although there is a work around, Google it and you will find a work around.

2. I also read that R2 is suppose to be better suited for a non relational database as far as the optimizer is concerned.

3. The backup compression is a NICE feature on R2..

456789psw SSCarpal Tunnel Points: 4728 More actions · Answer 3