Monitoring Page Faults

Use Windows Performance Monitor to track the number of hard page faults, which can indicate that the physical memory of the machine has been overallocated.

1. On the Control Panel, click Administrative Tools, then choose Performance.
2. Select the Sybase IQ process.
3. Select the counter Page Faults/sec.
   This counter includes both the soft and hard page faults. Hard page faults are the page faults resulting in disk I/O. Soft page faults in general are not a performance issue.
4. To determine the number of hard page faults, select the LogicalDisk object and the instance of where the file pagefile.sys is located (this should be on a separate volume from the Sybase IQ database).
5. Select the Disk Transfers/sec counter.

   This value when compared with the Page Faults/sec value will give an indication of the percentage of page faults that are hard page faults. Ideally there should be little to no I/O activity to the page file. In small memory configurations, however, paging is likely to occur.

   Sustained hard page fault rates above 20 per second indicate that the physical memory of the machine has been overallocated.