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
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.
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 ?
aha! looks like rortloff already said everything i was suggesting <img src='/community/emoticons/emotion-4.gif' alt='' />
Running Index Wizard against a Profiler trace would also be a good start. ------------------ Brad M. McGehee Webmaster SQL-Server-Performance.Com
