Posted by John Bell on 03/25/06 11:54

Hi

Changes in SP4 are documented in:
http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32sp4.htm#_database_and_desktop_engine_enhancements

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_spam@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?
>

• Next in forum: Re: Update n rows
• Prev in forum: Re: SQL Server 2005 install - no Management Server
• Thread view: Re: Performance Enhancements with Service Pack 4?

[Reply to this message]