We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

[sap-basis] After Upgrade from SQL2000 (x86) to SQL 2005 (x64) should I change boot.ini '/3GB /PAE' parameters?

Posted by Admin at
Share this post:
 Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

0 Comments

Posted by Superbasis (SAP Basis Administrator)
on Jan 30 at 3:26 PM
We just did an "upgrade" (detach,uninstall SQL2000 and then install SQL 2005 and attach DB) from SQL Server 2000 SP4 (x86) to SQL Server 2005 (x64). The O/S before and after upgrade is Windows Server 2003 x64. The server has 2x Dual core processors and 16 GB of RAM. SAP ECC 5.0 No unicode x64. All is workin fine, except that users complain of slow performance. So I workaround the situation and found out this:
Before upgrade the AWE switch was ON in SQL2000 and boot.ini had the /3GB /PAE parameters.
After upgrade to SQL 2005 the AWE switch is OFF(default) and boot.ini file remained the same (/3GB /PAE)
What configuration is recomended ?
1. Should I delete /3GB /PAE from boot.ini ? and keep AWE switch OFF at SQL 2005?
2. Or keep boot.ini file unchanged (with /3GB /PAE) and switch ON AWE at SQL2005 ?
3. Can this configuration be causing slow perfromance or should I look on other reason?
Thanks in advanced
Super
__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

T r a n s l a t e to your language