We have added search box. Key in SAP issue keyword to search
TopBottom

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

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:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by sriram kema
on Jan 30 at 4:23 PM
Mark this reply as helpfulMark as helpful
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
__.____._
Copyright © 2010 Toolbox.com and message author.

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

0 comments:

Post a Comment

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