Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Simon_L
Starting Member
32 Posts |
 Posted - 2008-10-16 : 05:24:08
|
| HiIm using perfmon and seeing relatively high amount of page faults.. I want to narrow this down to how many are caused by SQL... maybe an easy question but is it just the SQLSERVR proces i want or should I look at SQLAGENT, SQLMAGR etcmany thankssimon |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-21 : 12:52:38
|
| SQLServr is the one of interest, rest do not perform significant data processing to be of importance. |
 |
|
|
Simon_L
Starting Member
32 Posts |
Posted - 2008-10-22 : 05:32:43
|
| thank you very much for the reply .. appreciated :-)Simon |
|
|
|
Simon_L
Starting Member
32 Posts |
Posted - 2009-04-24 : 05:50:32
|
| Hi Im just revisiting this (!!)... I understand what page faults are etc... but Im not sure I understand what is the root cause of page faults i.e I understand teh symptom but not sure where it leads to as a diagnosing the cause .. best wishes simon |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-04-27 : 17:06:36
|
| http://technet.microsoft.com/en-us/library/cc768048.aspxPage faults frequently caused by lack of ram. |
|
|
|
|
|
|
Permon ~ Processes : Page Faults/Sec