cancel
Showing results for 
Search instead for 
Did you mean: 

Windows Page file and SQL AWE Correct Configuration

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member204746
Active Contributor
0 Kudos

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