-1

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..

2
  • How big are your databases? Jun 21, 2012 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, 2012 at 22:16

1 Answer 1

2

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.

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