How to check if a server runs in pressing mode
- by Ice
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.