Task Manager

[Mike]

When you bring up task manager and look on the processes
tab, then click view and columns, to view specific things,
and then select Page Faults, what are these Page Faults?
I'm seeing a large amount of them on verious processes,
but the one that concerns me the most is on SQL 2000. It
just keeps ticking up constantly.

 

[phoenix]

When you bring up task manager and look on the processes
tab, then click view and columns, to view specific things,
and then select Page Faults, what are these Page Faults?
I'm seeing a large amount of them on verious processes,
but the one that concerns me the most is on SQL 2000. It
just keeps ticking up constantly.

This quote:

"Page faults: This indicates the number of times that data had to be
retrieved from disk for this process because it was not found in memory.
This value is accumulated from the time the process is started. If you want
to know how many page faults are occurring incrementally, you can use Page
Faults Delta option. This delta is the difference between page faults
within the refresh interval of the Task Manager. High page faults indicate
that the server memory is under stress. You need to then find out other
applications that are competing for RAM and decide how to manage."

is from a page here http://snipurl.com/3vbq

Regards

Bill