June 13, 2011 at 8:52 am
Hello,
We have a sql server 2000 instance installed in one machine. I have the workload files for the server. Now if I use database engine tuning advisor from another machine to analyze the workload files and create indexes in the sql server 2000 instance, can there be any problem (since database engine tuning advisor is a sql 2005 tool)?
Thanks.
June 13, 2011 at 12:46 pm
Yep, you could hit issues. Also, the recommendations might include statements (such as the INCLUDE statement, ha) that won't work on 2000. There was a tuning advisor for 2000 databases. I'd use that.
However, I would recommend not using the DTA at all. It has put forward more bad recommendations than good ones in my experience.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 13, 2011 at 12:57 pm
Thanks for your reply. I used index tuning wizard, and when I selected the first trace workload file, it did not select the other rollover files automatically. So I had to create a table to read all data from the workload files to use it with ITW.
Is there anyway I can select all workload files with ITW?
June 13, 2011 at 1:00 pm
Sorry, I can't help you there. I don't have a 2000 instance available any more to test it out. You might try posting in the 2000 forum.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply