Hi there,

Layout:

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.

Questions:

• 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.