Post reply

Profiler Event Called Scans

  • December 13, 2006 at 12:44 pm

    #114879

    I am using SQL 2000 and I am doing a trace on a db. I noticed the event called "Scans" and inside there is "Scan Started" and "Scan_Stopped" Does anyone know what this means and what type of scan profiler is tracing?

    Thanks

    Gary

  • December 14, 2006 at 4:29 am

    #678032

    According to books Online (2005)

    The Scan:Started event class occurs when a table or index scan is started.

    The Scan:Stopped event class occurs when a table or index scan stops.

    I've used them before to get an idea which of my tables get the most scans. Be warned, there will be lots of ocurences of that event. I had thousands/sec

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 15, 2006 at 4:37 am

    #678294

    I don't wish to sound rude but running a profiler trace and setting options not understood seems a bit strange to me. You might try the SQL 2000 Performance tuning technical reference

    isbn 0-7356-1270-6

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • December 16, 2006 at 12:04 am

    #678512

    You can find the meaning of the trace events in the profiler itself when you click on the event at the bottom it will tell what it is...

     

    MohammedU
    Microsoft SQL Server MVP

  • December 18, 2006 at 10:02 am

    #678717

    By setting options one does not understand offeres the opportunity to learn about them!

    The trace I am referring to is not on a production machine but a machine on which all of our staff experiments and learns. Criticizing one for exploring and learning is not what I beleive this forum to be about.

    Gary

  • December 18, 2006 at 10:07 am

    #678720

    I got to save this answer... it will come in handy someday.

     

    Thanx GF .

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply