Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  FInd table/index scans

Author  Topic  Matt_S Starting Member 1 Post Posted - 2010-03-02 : 14:36:24 Hope this is the right foum. I noticed that the Scan:Started event in SQL Server Profiler also fires on index seeks. I included the Showplan All event class and I can see that a scan is started even though the plan shows a seek. Is there any way to find table/index scans?