Hi all. Dorky question , but I am still relatively new to the world of
ms database servers so bare with me. I am monitoring the page fault
rate on a server and it runs at 100% almost all of the time. Can
someone help me understand what that means?

"sumGirl" <emebohw [at] netscape.net> wrote in message
news:a5e13cff.0410150725.60465338 [at] posting.google.com...
> Hi all. Dorky question , but I am still relatively new to the world of
> ms database servers so bare with me. I am monitoring the page fault
> rate on a server and it runs at 100% almost all of the time. Can
> someone help me understand what that means?

A page fault is when a memory page is not where it's expected to be, and the
data has to be read/updated in another memory location, or from the hard
drive. More information here:

http://www.sql-server-performance.com/q&a114.asp

Simon