SQL Server Performance

Maximum number of rows to allow in a SQL trace for use in Database Engine Tuning Advisor?

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by biged1234567, Sep 18, 2008.

  1. biged1234567 New Member

    Greetings all, Just wondering if there is know maximum for the number of rows you can capture in a SQL trace that you will then use to tune indexes in tuning advisor. I seem to remember SQL 2000 tuning having issues with anything over 1 million rows. Any help is greatly appreciated.
  2. Luis Martin Moderator

    That is a bad idea.
    My suggestion is to, after trace, find queries with long duration or cpu.
    Copy and paste into Management Studio, check execution plan, and call DTA from there.
    If run DTA, no matter how many rows, DTA will give you a big picture about indexes and, may be, not exactly what you need.

Share This Page