Perfmon: Batch Requests/sec

• Richard McSharry

  Ten Centuries

  Points: 1249

  More actions

  September 15, 2008 at 6:43 am

  #192825

  Hi,

  From notes I took on Performance Monitor counters, two of those listed are:

  SS: Access Methods - Page Splits/sec

  SS: Buffer Manager - Page Lookups/sec

  My notes say that I should compare these to Batch Requests/sec, but I cannot find this counter. Does anyone know where I can find it in Perfmon?

  Thanks,

  Richard

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  September 15, 2008 at 7:19 am

  #871717

  You should find it in the :SQL statistics object

• Richard McSharry

  Ten Centuries

  Points: 1249

  More actions

  September 15, 2008 at 8:10 am

  #871760

  You are correct, I've found it, so thank you for the help.