OK folks, here's a good one for you...
I have a Compaq ML570 server here running MS SQL 7.0 on Windows 2000 Server SP-4.
Here are the specs:
4x Xeon 700 2MB cache processors
3GB
RAM
6x 18 & 6x 36GB U320 Hard Drives on a SmartArray 5200 Controller
blah blah blah...
There is 2GB
RAM dedicated to SQL. At peak usage (today anyway) we're using 1.95GB of
RAM on this puppy. We've asked the DBA to leave at least 1GB for other functions (backups, services, Unreal 2003, etc)
This is the problem: The DBA here wants to run a 5GB paging file for this monster. No problem; it's up and running on 2 18GB drives in a RAID-0 config. This is my question:
Since these are 32-bit processors, will this be a waste of hard drive space? Remember Xeon processors use a SHARED memory structure, so the way I see it, they can only address 4GB of
RAM. Is the last 4GB (on the paging file) going to waste? Should I already know the answer to this question?
Any help is appreciated, and I thank you in advance.