Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a 64 bit Machine that runs SQL Server. It has 64 GB RAM.

It is giving around 1,000,000 Page Faults per second. Is it OK or it is giving too many Page Faults? if the number is hign the what should I do to resolve this problem?

Thanks for your help..

share|improve this question

closed as not a real question by Wesley, voretaq7 Jul 19 '12 at 22:15

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

How big are your databases? – Matthew Iselin Jun 21 '12 at 7:16
We would need more information in order to answer this question (why are the page faults happening: Are you running other software? Is your DB just that big?, etc...) – voretaq7 Jul 19 '12 at 22:16

This means that 1 b times per sec, sql requires access to a memory space that is mapped in the OS, but not yet loaded in physical memory (still on disk) So there are possibly a very high I/o too ("hi" column in "top").

It's difficult to answer how to fix this, I'm no SQL expert, but this is clearly sub-optimal.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.