Database Tuning Advisor

microsoft.public.sqlserver.tools

14 Sep 2006 5:53 PM

Peter L.

Are there any issues using the 2005 Database Tuning Advisor on 2000 servers?

--
-Peter

14 Sep 2006 11:37 PM

Warren Brunk

here are the Unsupported Tuning Options for using the DTA...
http://msdn2.microsoft.com/en-us/library/ms345360.aspx

Having used the New DTA on my SQL 2000 databases I can say I havent ran into
any issues. A huge improvement to say the least...

http://msdn2.microsoft.com/en-us/library/ms170735.aspx

--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/

Show quote

"Peter L." <Pet***@discussions.microsoft.com> wrote in message
news:7552F213-30AF-4AAE-BB1A-612CF88D973F@microsoft.com...
> Are there any issues using the 2005 Database Tuning Advisor on 2000
> servers?
> --
> -Peter