Memory:Pages/sec and Memory: Page Faults/sec acceptable THRESHOLDS

• Bikeman

  Ten Centuries

  Points: 1207

  More actions

  December 17, 2004 at 9:42 am

  #91716

  Hi,

  Just wondering if anyone has good acceptable values for the thresholds for these sql counters:

  Page Faults/sec

  Pages/sec

  

  Thanks in advance

• Jimmy Jen

  SSCrazy

  Points: 2915

  More actions

  December 17, 2004 at 12:59 pm

  #534365

  A low rate of  Pages Faults/sec (commonly 5-10 per second) is normal. See article:

  http://www.devarticles.com/c/a/SQL-Server/SQL-Server-Hardware-Tuning-and-Performance-Monitoring/2/