MS SQL Server - Scan events

Author

Scan events

Alex

2006-10-24, 6:37 pm

Hi friends,

I'm curious about those events. Profiler shows scans regardles whether it's
index seek or real index scan. And values in Mode column seem to be not much
of help to filter out index seeks. What are they about in fact? Did anyone
use them for anything?

Thanks a lot in advance.

Alex

Alex

2006-10-24, 6:37 pm

No one can explain why index seek on primary key throws out index scan
events in Profiler?
Gentlemen from SW giant, could you please elaborate a bit on that? After all
it is your recomendation to check out those events.

Alex

"Alex" <me@isp.net> wrote in message news:ibzXg.11430$P7.7834@edtnps90...
> Hi friends,
>
> I'm curious about those events. Profiler shows scans regardles whether
> it's index seek or real index scan. And values in Mode column seem to be
> not much of help to filter out index seeks. What are they about in fact?
> Did anyone use them for anything?
>
> Thanks a lot in advance.
>
> Alex
>
>

Greg Linwood

2006-10-24, 6:37 pm

Hi Alex

I posted in another thread ~ 1 week ago ( http://tinyurl.com/ye7oc6 ) about
how I posted a question to the private SQL Server MVP discussion forum. I
never got an answer from anyone at MS in that discussion, so I don't like
your chances on getting a meaningful response out here..

I'd encourage you to place a call to PSS as they have a responsibility to
fix bugs.. Hopefully they'll do something about this even if enough people
request it be fixed..

Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood

"Alex" <me@isp.net> wrote in message news:opFXg.14528$P7.2514@edtnps89...
> No one can explain why index seek on primary key throws out index scan
> events in Profiler?
> Gentlemen from SW giant, could you please elaborate a bit on that? After
> all it is your recomendation to check out those events.
>
> Alex
>
>
> "Alex" <me@isp.net> wrote in message news:ibzXg.11430$P7.7834@edtnps90...
>
>

Alex

2006-10-24, 6:37 pm

Thanks Greg,

so I'm not alone in my...feelings.
Profiler is quite known for its mischievous behaviour, - I ran into such
case when it showed incorrect events and it was later confirmed from within
MS whereas server-side trace was always accurate source of trace data, well,
at least to my experience. But deplorably enough in this case both methods
are not trustworthy.

Alex

"Greg Linwood" <g_linwood@hotmail.com> wrote in message
news:%23EVAYBq7GHA.3760@TK2MSFTNGP02.phx.gbl...
> Hi Alex
>
> I posted in another thread ~ 1 week ago ( http://tinyurl.com/ye7oc6 )
> about how I posted a question to the private SQL Server MVP discussion
> forum. I never got an answer from anyone at MS in that discussion, so I
> don't like your chances on getting a meaningful response out here..
>
> I'd encourage you to place a call to PSS as they have a responsibility to
> fix bugs.. Hopefully they'll do something about this even if enough people
> request it be fixed..
>
> Regards,
> Greg Linwood
> SQL Server MVP
> http://blogs.sqlserver.org.au/blogs/greg_linwood
>
> "Alex" <me@isp.net> wrote in message news:opFXg.14528$P7.2514@edtnps89...
>
>

Sponsored Links