Reports the number of major and minor page faults, and a summary of all page faults. sp_sysmon prints this section only if there are reported page faults.
“Page Faults at OS” does not appear
for Windows.
Minor Faults – occur when Adaptive Server needed a memory page that was not marked as available in the memory management unit, but was available in physical memory.
Major Faults – occur when Adaptive Server needed a memory page that was unavailable in physical memory and had to retrieve the page from disk.
Both minor and major page faults indicate a potential shortage of physical memory. Major page faults carry a far greater performance penalty than minor page faults. Major page faults indicate that you have set the Adaptive Server memory configuration too high for the host, or that other processes (such as a file system cache) are using the physical pages Adaptive Server expects.
