on 08-03-2007 11:39 AM
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
2046MB of pagefile is really not enough. increase to 20GB is possible.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.