locked
What is Page Fault in sql 2005/2008 RRS feed

  • Question

  • What is Page Fault in SQL 2005/2008?
    Thursday, March 15, 2012 1:34 PM

Answers

  • Take a look at this

    http://www.sql-server-performance.com/forum/threads/help-with-high-page-faults-sec.15407/

    • Marked as answer by VijayKSQL Thursday, March 15, 2012 4:57 PM
    Thursday, March 15, 2012 3:51 PM

All replies

  • In general

    http://en.wikipedia.org/wiki/Page_fault

    In SQL server terminology

    if SQL Server process can not find a page in the memory and must retrieve it from the disk it is called hard page fault.

    In contrast Soft page fault occure when page is not found in SQL Server memory address space but found somewhere else in the memory.



    • Edited by Chirag Shah Thursday, March 15, 2012 1:59 PM
    Thursday, March 15, 2012 1:48 PM
  • Take a look at this

    http://www.sql-server-performance.com/forum/threads/help-with-high-page-faults-sec.15407/

    • Marked as answer by VijayKSQL Thursday, March 15, 2012 4:57 PM
    Thursday, March 15, 2012 3:51 PM