SQL Profiler Scan:Started/Stopped events

#1

(Cross-posting from general SQL newsgroup)

I 2nd vler's request to understand better what the definitions for all of
the values of the "Mode" property are within Scan:Started/Stopped events...

How does one distinguish a Scan vs. a Seek if the Scan:Started/Stopped
events are fired for both??

Thank you,
-Darius

"vler" wrote:

Quote:

Thank you for your response. I investigated Scan:Started and
Scan:Stopped events, as well, but they are fired even for index
seeks.

I'd like to identify them and exclude them from my trace.

There is a "Mode" column that I can filter on:
1 = Normal
2 = First
4 = Back
8 = Unordered
16 = No data
32 = Reserved
64 = Exlatch
128 = Index supplied
256 = Marker

but what is the meaning of those? How do I distinguish scans only?

On Jul 3, 12:30 pm, "Uri Dimant" <u... (AT) iscar (DOT) co.il> wrote:
vlerhttp://www.sql-server-performance.com/tips/sql_server_profiler_tips_p....

"vler" <VladaE... (AT) gmail (DOT) com> wrote in message

news:928fe53c-59ac-41b7-afbf-b825bea94935 (AT) 34g2000hsh (DOT) googlegroups.com...

Hi,

I'm using SQL Server 2000 sp4. Huge database (100+ tables), huge
application.

Is there a way to use SQL Profiler to filter out all table/index
scans?

I get some info with SP:Completed and SP:StmtCompleted ("Reads"
column) but especially for cascade deletes I cannot easily figure out
what's being scanned.

Runing the query in QueryAnalyzer gives me the info, but I'd need to
identify the queries first.

Thanks!- Hide quoted text -

- Show quoted text -

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Profiler Scan:Started/Stopped events

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

SQL Profiler Scan:Started/Stopped events - 07-21-2008 , 08:28 AM