Full scans per second?

• Jason Marshall

  SSCommitted

  Points: 1791

  More actions

  March 18, 2008 at 10:26 am

  #379254

  Good morning-

  Does anyone know what 'acceptable' values are for this performance counter (found in SQL Server Access Methods)? I'm monitoring this for a data warehouse/reporting application.

  Thanks!!

• Scalability Doug

  SSCertifiable

  Points: 5351

  More actions

  March 18, 2008 at 11:04 am

  #790994

  Yes Jason. Check out this linke http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64044 for the full scans/sec and other acceptable counter values.

  DAB

• SanjayAttray

  SSChampion

  Points: 13157

  More actions

  March 18, 2008 at 12:58 pm

  #791069

  SQLServerLifer (3/18/2008)

  ---

  Yes Jason. Check out this linke http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64044 for the full scans/sec and other acceptable counter values.

  DAB

  Thanks DAB. useful link. I was in search for these counters for perfmon analysis.

  SQL DBA.

• Jason Marshall

  SSCommitted

  Points: 1791

  More actions

  March 18, 2008 at 1:05 pm

  #791077

  DAB, thanks! Exactly what I am looking for...

  jm

• Scalability Doug

  SSCertifiable

  Points: 5351

  More actions

  March 18, 2008 at 1:23 pm

  #791087

  Glad I could help.

  DAB