cache hit ratio

[timc]

I have a large dell server with 4 processors, and 8 gig of memory on win 2000 advanced with sql 2000 enterprise edition running a 3rd party app. My cache hit ratio averages about 76%. I thought the gneral rule was if you get below 80% to add more memory. However my memory manager shows I am only using 71% of my memory and have a full gig available. I have the sql server set to use about 7.1 gig of the 8 gig on the server. My ? is if I am only using 71% of my memory, will will adding more memory actually help my cache hit ratio

[rmiao]

If you put '/3gb' and '/pae' in boot.ini file and enabled awe, sql should be able to use around 7gb memory.

[timc]

I have the awe enabled, I did notice that we only have 1 2 gig page file on this server. It is attached to a SAN, any thoughts about putting page files on the SAN

[rmiao]

Should be ok although I prefer to put it on local disk.

[timc]

The way the client bought the machine from dell, it only has 1 raid10 array for the os, and I only have 5 gig left

[timc]

I did check and my page file %usage is about 93%