We had a situation with Windows 2003 server where applications were failing and timing out with 6GB, but with 10GB the problem went away. There was a SQL app in particular that dragged everything down. The only clue we had were messages about Hard Page faults. In the past we've seen these but they never were a problem - more like the occasional glitch message that doesn't seem to amount to much - when you check RAM/CPU - everything looks ok. Yet there's a problem.
Can anybody provide me with some rules of thumb for page faults?
How Many Hard Page Faults are Too Many?
Page Fault Delta?
Links appreciated. Similar experience even more appreciated.