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 sriram kema on Jan 30 at 4:23 PM | |
Hi Super,
There is no use of 3BG\PAE in x64 machine; please check you SAP and MSSQL
memory settings make sure it is assigned as 70/30 ratio.
Thanks, SRI.
On 1/30/10, Superbasis via sap-basis <sap-basis@groups.ittoolbox.com> wrote:
>
> 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
__.____._ There is no use of 3BG\PAE in x64 machine; please check you SAP and MSSQL
memory settings make sure it is assigned as 70/30 ratio.
Thanks, SRI.
On 1/30/10, Superbasis via sap-basis <sap-basis@groups.ittoolbox.com> wrote:
>
> 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
Related Content
In the Spotlight
White Papers
In the Spotlight
Share Knowledge About SAP Scripting. Join the New Discussion Group
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