Re: Database Page Faults/sec

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



A database page fault occurs whenever a page is read that is not already in
database cache. It's really a reflection of read activity.

A database page fault stall occurs when, after a page fault, a page cannot
be read into cache because all of the pages in cache are locked. This
number should always be 0. A number larger than 0 would indicate a serious
bottleneck.

You'd be much better off looking at physical disk - average sec/write when
trying to determine if you have a disk bottleneck. If you average more than
20 ms or have spikes lasting more than a few seconds over 50 ms, the you
have a poorly performing disk subsystem.

BES essentially opens an uncached MAPI session for each BES user an polls.
To se high read activity for BES would not be out of the ordinary. I
believe it's the RIM whitepaper (referenced in optimizing storage) that
states a Blackberry user is 3.64 times the IO of a non blackberry user.

Are the storage subsystems on each of your servers appropriately sized to
handle the extra load?


"Mark Dolan" <MarkDolan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1C3031EA-733B-4CDC-A945-D92A4629B1E0@xxxxxxxxxxxxxxxx
Can someone tell me what an acceptable level for Databse Page Faults/sec
should be. I've got three servers and that perfmon counter is pegged out
on
two of them (averaging 1,914). The other server has an average of 215.

We're having some bad blackberry issues (delivery delays to the handheld)
on
the two with the high Database Page Faults. All other counters seem to be
OK, this is the only one we see that is high.


.



Relevant Pages

  • Re: AS2005 ... what is wrong with it?
    ... the question is not cold cache and warm cache during query time. ... stop both servers 32bits and 64bits ... the OLAP database. ...
    (microsoft.public.sqlserver.olap)
  • Re: AS2005 ... what is wrong with it?
    ... A new data folder should have been created at \data ... Restore the backup of the database ... I saved the create role XMLA on both servers then I restarted the AS ... no it's not a cold cache thing.... ...
    (microsoft.public.sqlserver.olap)
  • Re: LDAP Performance (long)
    ... Cache the slapd's internal database lookups in slapd memory. ... The first is the new TAG:key lookup, ...
    (comp.mail.sendmail)
  • Re: Cache-Size vs Performance
    ... logarithmic decrese in the miss rate as the cache size grows ... in big database applications ... ... where the database uses real storage to compensate for disk record ... database people in stl/bldg90 and the relational/sql system/r people ...
    (comp.arch)
  • Re: Running queries on large data structure
    ... ugly to convert it into some relational shape for the database) ... of time when reloading them from disk but YMMV and you would have to ... pickle it and load it later and work on the data? ... My data layer checks the cache ...
    (comp.lang.python)