May 1, 2008 at 1:41 am
can any one confirm me that if advices generated by Database Engine Tuning Advisor (sql2k5) are efficently effective on sql2k database.
ie. I am having production database on sql2000 but my testing database server is sql2005. So, data that i collect from DTA for tuning purpose will be effective on actual running production database or not..
waiting.............
May 1, 2008 at 6:34 am
No. That's a bad plan. If you're maintaining a 2000 database, you should be testing against a 2000 database. There were changes, not necessarily big ones, but they're there, to the optimizer that means that it's possible for an index to work well on 2000, but not on 2005 and vice versa. Don't keep working like this.
"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 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply