spike in full scans/sec

• dweil

  SSCrazy

  Points: 2408

  More actions

  August 8, 2008 at 8:18 am

  #196731

  IMHO we have a relatively well tuned sql server box. Recently I noticed a spike in full scans/ sec. Nothing horrible but we went from very rarely having a full scan to averaging over 10 in the performance monitor. Now for what would seem like a simple question. How do identify which of our 20 databases is actually causing to spike in full scans. I would think it would be a filter in profiler but I could not find one that would be appropriate.

  Thanks

  David Weil

• GSquared

  SSC Guru

  Points: 260824

  More actions

  August 8, 2008 at 11:09 am

  #855400

  You can create traces with customer filters. Books Online has the details on how to do that.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon