SQL Server Performance

Full scans

Discussion in 'Performance Tuning for DBAs' started by harold_salazar, Feb 17, 2003.

  1. harold_salazar New Member

    I have ran a windows performance monitor against my database and i found the counter Full Scans/seg measuring 32 for about 3 hour. Also I found 68 scans/seg during 30 min.
    That happened during an intensive work process.
    Are those numbers normal or there is something wrong there.

    Thnaks
  2. sqljunkie New Member

    It depends on what type of scans and what the response time of the queries are when the scan activity increases.
    You can capture query execution plans in profiler. If you are concerned about a performance issue try to eliminate table scans, clustered index scans and secondary index scans by adding or rearranging indexes on tables.
  3. Chappy New Member

    It sounds like its high enough to warrant investigation to me. It would be useful to know what sort of scans are taking place (index vs table), run profiler to capture the queries and examine the execution plan of some of the more intensive ones: some of the queries might benefit from extra indices, or being restructured.
    What is your disk I/O queue and wait-time like?
    Did you profile these stats as a result of a performance problem ?
  4. Chappy New Member

    aha! looks like rortloff already said everything i was suggesting <img src='/community/emoticons/emotion-4.gif' alt=':p' />
  5. bradmcgehee New Member

    Running Index Wizard against a Profiler trace would also be a good start.

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com

Share This Page