asked on

Windows Server 2003 Ent 64 Bit Paging File

I have a 64 Bit Server with running SQL 2005.
The system seems to run into a paging file issue.
What's the recommend size for this Paging file.

OS Name	Microsoft(R) Windows(R) Server 2003 Enterprise x64 Edition
Version	5.2.3790 Service Pack 2 Build 3790
Other OS Description 	R2
OS Manufacturer	Microsoft Corporation
System Name	
System Manufacturer	HP
System Model	ProLiant DL380 G5
System Type	x64-based PC
Processor	EM64T Family 6 Model 23 Stepping 10 GenuineIntel ~2833 Mhz
Processor	EM64T Family 6 Model 23 Stepping 10 GenuineIntel ~2833 Mhz
Processor	EM64T Family 6 Model 23 Stepping 10 GenuineIntel ~2833 Mhz
Processor	EM64T Family 6 Model 23 Stepping 10 GenuineIntel ~2833 Mhz
Processor	EM64T Family 6 Model 23 Stepping 10 GenuineIntel ~2833 Mhz
Processor	EM64T Family 6 Model 23 Stepping 10 GenuineIntel ~2833 Mhz
Processor	EM64T Family 6 Model 23 Stepping 10 GenuineIntel ~2833 Mhz
Processor	EM64T Family 6 Model 23 Stepping 10 GenuineIntel ~2833 Mhz
BIOS Version/Date	HP P56, 7/10/2009
SMBIOS Version	2.4
Windows Directory	C:\WINDOWS
System Directory	C:\WINDOWS\system32
Boot Device	\Device\HarddiskVolume7
Locale	United States
Hardware Abstraction Layer	Version = "5.2.3790.3959 (srv03_sp2_rtm.070216-1710)"
User Name	Not Available
Time Zone	Eastern Standard Time
Total Physical Memory	16,381.66 MB
Available Physical Memory	10.46 GB
Total Virtual Memory	17.40 GB
Available Virtual Memory	12.24 GB
Page File Space	2.00 GB
Page File	C:\pagefile.sys

Open in new window

ASKER CERTIFIED SOLUTION

ipajones

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ericnils

Unfortunately there is no clear answer since it depends on how you are using your server. Windows automatically creates a page file 1.5 times the size of physical memory when it is installed. It looks like your server was installed with less memory or someone shrunk your page file. I suggest jumping to the "How to calculate page file size" section of this article:

http://support.microsoft.com/kb/889654

Darius Ghassem

The recommended amount for a page file is 1.5 times your current memory installed

http://www.petri.co.il/pagefile_optimization.htm

yo_bee

ASKER

Same as a previous response

yo_bee

ASKER

This is in regards to the same server.
It is a SQL server. Should the Memory Usage be set to Programs or System Cache?

Right now it is set to System Cache.

ipajones

It should be set to "System Cache" if it's a server - so your current setting is correct.