Microsoft SQL Server forum - Performance Enhancements with Service Pack 4?

Author

Performance Enhancements with Service Pack 4?

imani_technology_spam@yahoo.com

2006-03-23, 1:31 pm

We are running SQL Server 2000 in a 32-bit environment. Are there any
performance enhancements included in the new Service Pack 4? If so,
how do those enhancements compare to SQL Server 2005?

John Bell

2006-03-25, 7:40 am

Hi

Changes in SP4 are documented in:
http://download.microsoft.com/downl...nce
ments

There are performance improvements in SP4 but (I think) these will only be
applicable if you are using specific features whereas improvements in SQL
2005 may be more across the board. You would have to do your own benchmarks
to see how big the improvement with SQL 2005 is.

John

< imani_technology_spa
m@yahoo.com> wrote in message
news:1143132962.194882.97580@g10g2000cwb.googlegroups.com...
> We are running SQL Server 2000 in a 32-bit environment. Are there any
> performance enhancements included in the new Service Pack 4? If so,
> how do those enhancements compare to SQL Server 2005?
>

Sponsored Links