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 Lars-Erik Hallsten (CEO & Senior Consultant) on Jan 30 at 3:59 PM |  Mark as helpful |
Hi,
1. AWE, /3GB and /PAE is not supported on 64-bit platforms.
2. See above.
3. No, I wouldn't think that these switches are the cause of your
performance reasons. If you turn on /3GB on a server with more than 16 RAM,
it will prevent the server from using it, but this does not apply to you,
since your server has 16GB RAM.
You should ask the users where they experience slow performance and if it
applies to all or just some users.
Check response times statistics in tcode ST03N
Regards,
LEH
From: Superbasis via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 30. januar 2010 9:25
To: Lars-Erik Hallsten
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
__.____._ 1. AWE, /3GB and /PAE is not supported on 64-bit platforms.
2. See above.
3. No, I wouldn't think that these switches are the cause of your
performance reasons. If you turn on /3GB on a server with more than 16 RAM,
it will prevent the server from using it, but this does not apply to you,
since your server has 16GB RAM.
You should ask the users where they experience slow performance and if it
applies to all or just some users.
Check response times statistics in tcode ST03N
Regards,
LEH
From: Superbasis via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: 30. januar 2010 9:25
To: Lars-Erik Hallsten
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
Lars-Erik HallstenSAP 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
_.____.__ 
