Home Forums SQL Server 2008 SQL Server 2008 Administration Track queries that caused index scan RE: Track queries that caused index scan

  • February 22, 2013 at 3:27 am

    #1590267

    pooyan_pdm (2/21/2013)

    Thanks for your reply. I was looking for a way other than searching the plan cache.

    The only way to find out what queries had specific query plan operators is to search the query plan cache.

    Also, be careful about scan started and those kind of events, that doesn't necessarily mean a full index scan. Could be a range scan (ie an index seek)

    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