i have at customer side a server (win2003 R2 SP2 standard edition 32-bit) with a sql-server 2005 and some databases. This system starts with the /3GB-Switch. The system reports 3.25 GB RAM and taskmanager reports the process of sqlserver.exe with 2758255 K as the process with the highest consumption.
The OS separates RAM for applications and for itself, normaly 50:50. But here we have the /3GB-Switch aktivated and i think the part for the applications is more than 50% of RAM.
Knowledge (or better not knowledge):
Somebody told me that if the OS runs out of memory within his part of RAM, the server runs into pressing mode.
What is this pressing mode?
Is pressing mode possible at all in this szenario?
What should be done to get more performance out of this sql-server, beside optimizing the database and all this stuff.