SQL Server Performance Forum – Threads Archive
Full Scans/sec
I found that Full Scans/sec means the Number of unrestricted Full Scans per second (These can either base-table or full-index scan). So, what us the meaning of full-index scan? What is the reasonable figure for this indicator under SQL Server Access Methods in Performance Application? Thankshttp://www.sql-server-performance.com/performance_monitor_counters_sql_server.asp information about SQL Server Access counters. Number of index searches per second. These are used to start range scans and single index record fetches and to reposition an index. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>