RE: [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:
|
|
0 Comments
 | Posted by D. Caddick (SAP NetWeaver/BASIS Consultant) on Jan 30 at 4:09 PM |  Mark as helpful |
Hi,
You should remove the settings '/3GB /PAE from boot.ini and keep AWE off in
a 64Bit system.
Have you set the memory parameters as per SAP note: 88416?
Regards
From: Superbasis via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 30 January 2010 20:25
To: D. Caddick
Subject: [sap-basis] After Upgrade from SQL2000 (x86) to SQL 2005 (x64)
should I change boot.ini '/3GB /PAE' parameters?
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
__.____._ You should remove the settings '/3GB /PAE from boot.ini and keep AWE off in
a 64Bit system.
Have you set the memory parameters as per SAP note: 88416?
Regards
From: Superbasis via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 30 January 2010 20:25
To: D. Caddick
Subject: [sap-basis] After Upgrade from SQL2000 (x86) to SQL 2005 (x64)
should I change boot.ini '/3GB /PAE' parameters?
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
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
D. CaddickSAP Basis Helper
Posted helpful replies on 50 threads in a group to earn a Silver Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
