Home / server / Questions / 102690
Accepted
Ice
Asked: 2010-01-15 06:29:36 +0800 CST

How to check if a server runs in pressing mode

  • 772

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.

sql-server-2005 windows-server-2003

4 Answers

  1. Never heard about this "pressing mode", and Google can't seem to find nothing about it; howewer, this could actually be a problem, but usually it isn't.

    It's quite difficult for the kernel to actually use up a whole GB of memory; this could happen with memory-intensive device drivers, or if you also enable the /PAE switch, which induces increased memory management overhead.

    The best option here would be switching to x64 Windows; even if you only have 4 GB of physical memory, you could at least use all of them and not need to worry about kernel/user space issues anymore. You're using SQL Server 2005, so this is a viable option (unless you have other application issues).

    • 1

  2. I've never heard of "pressing mode" but you can read more than you probably want to know about windows memory handling in this answer. The first thing I'd do to optimize this server is see if you can get the system rebuilt as 64 bit.

    • 0

  3. You sure that the one who told you about this "pressing" mode didn't actually call that thing "paging"?

    • 0
  4. Best Answer

    thanks for your attention. i regrett my humble question but the problem is described om the following blog. http://blogs.msdn.com/slavao/archive/2006/11/13/q-a-does-sql-server-always-respond-to-memory-pressure.aspx

    I found it in neverending research and it's exact what i meant.

    • 0