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.
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!