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.

   biged1234567, Sep 18, 2008

   #2
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.
   

   Luis Martin, Sep 18, 2008

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in