SQL Server Performance Forum – Threads Archive
Service Pack 4guys, I would like to know the experience of installing sp4 ? (in production) any hiccups ? or is it recommended or wait & watch ? bj
Till now, no problem at all.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
I also do not have any problems up tone
But I heard that there is a problem with AWE enabled cases and you will not be able to uninstall the SP4
quote:Originally posted by bj007 guys, I would like to know the experience of installing sp4 ? (in production) any hiccups ? or is it recommended or wait & watch ? bj
Check, if thishttp://www.microsoft.com/sql/downloads/2000/sp4.mspx applies to you —
SQL Server MVP
Theirs’s no issue … i have been installed and using it . hsGoswami
I feel it depends on how technically you’re using the SQL and application servers.
Always test, test and test on the testing environment before going on production, its good to take others opinion but it is your call so you should be prepared for any result. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Issues exist: BUG: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 SP4
http://support.microsoft.com/default.aspx?scid=kb;EN-US;899761 Only half of your memory will be available to SQL Server.