How to find table scans?

[friendlystar99]

How to find if table scans are occuring or not on the server? I guess we can use profiler but can cany one explain me the steps? or is there any sp out there that can be run to find out?
Thanks,
Di.

[MAK]

if you are running a procedure or a select statement in the query analyser you just do a CTRL + L on a selected query and see the execution plan.

Execution plan explains it.

[skhanal]

You can trace

SQLServer:Access Methods - Full Scans/Sec

counter in Profiler for over all table scans. For a specific query you can capture the explain plan in profiler or in query analyzer.

[friendlystar99]

Thanks, but which event in profiler? when I run on Enterprise mgr?

[skhanal]

For SQLServer:Access Methods - Full Scans/Sec
you have to use system monitor.

But in profiler you can use performance event - explain plan

or scan event.