SQL Server Performance Forum – Threads Archive

Service Pack 4

guys, 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.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
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

---

Check, if thishttp://www.microsoft.com/sql/downloads/2000/sp4.mspx applies to you —
Frank Kalis
SQL Server MVP
http://www.insidesql.de

---

Hi All,
Theirs’s no issue … i have been installed and using it . hsGoswami
[email protected]

---

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
Moderator
http://www.SQL-Server-Performance.Com/forum
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.

---

]]>