SQL Server Performance Forum – Threads Archive
Full Scans/secI 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? Thanks
http://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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.