Post reply

Full Table Scans

  • June 1, 2004 at 7:22 am

    #162597

    Hello guys,

    Could someone tell me if there is a way to write a t-sql script to track sql queries performing full table scans?

    Thanks a lot,

    Thierry

  • June 1, 2004 at 7:36 am

    #508500

    Hi,

    Use SQL Profiler and trace TSQL and Stored Procedure events.

    Then search the textdata column.

    I hope this helps...


    Andy.

  • June 1, 2004 at 7:44 am

    #508501

    Hello Andy,

     

    How can I then detect full table scan in textdata?

    Thierry

  • June 1, 2004 at 8:26 am

    #508511

    Full table scan can be select * from table OR

    Ignoring indxes -- Which one is bugging you?

     

     

     


    Andy.

  • June 2, 2004 at 7:14 am

    #508647

    I'm monitoring servers with windows performance monitoring tool, sql server access method object, full table scans/sec counter. When I see that the counter is high I would like to see which sqls are performing full table scans

  • June 4, 2004 at 2:29 am

    #508963

    No one have an idea???

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

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