Skip to Content
avatar image
Former Member

Windows Page file and SQL AWE Correct Configuration

Hi everyone,

I have SQL ENT. 2005 and Windows ENt w2k3 I Have 9 Gig of Physical Mem

2 Dual Processor 2x72 GIG Raid 1 SCSI 3x72 Raid 5, I got slow performance on my SAP B1 2005 my current database is 45gig

current config and stats

Windows Virtual Mem config is min 1024 max 2048

SQL AWE min 5120 max 6144

boot.ini config

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect /PAE

can anyone help me if this is correct, need your advice whats the best practice between AWE and VM Pagefile.sys

clifford

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 06, 2007 at 07:22 PM

    2046MB of pagefile is really not enough. increase to 20GB is possible.

    Add comment
    10|10000 characters needed characters exceeded