full scans/sec & index searches/sec | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

full scans/sec & index searches/sec

I have been monitoring the performance on my server using perfmon and profiler. I am trying to find the cause of our performance problems. I believe we may have an indexing problem. In perfmon I am seeing that there are about 2700 full scans/sec and 3300 index searches/sec. I am thinking that my full scans should be much less than the index searches and they are not. Is this truly the case? I am calculating this out to be 45% and higher of the scans are full scans. Does anyone have any suggestions on what values I should be looking at as normal or preferred for these two counters?
Duplicate post, the subject continue in: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=7439 Please lock it.
Luis Martin
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.