Kevin Remde's IT Pro Weblog
IT Pro Resources
TechNet EventsMicrosoft Security Response CenterMicrosoft Virtual AcademyKevin’s Evaluation Download Center
IT Pro Evangelist Blogs
Blain Barton Blain Barton's Blog@BlainBar
Brian LewisMy Thoughts on IT...@BrianLewis_
Dan Stolts IT Pro Guru Blog@ITProGuru
Jennelle Crothers TechBunny@jkc137
Kevin RemdeFull of I.T.@KevinRemde
Tommy PattersonVirtually Cloud 9@Tommy_Patterson
Yung Chou Yung Chou on Hybrid Cloud@YungChou
SQL Server 2005 Tidbit 037
This question was asked at our event TODAY in Des Moines, IA.
“Can the SQL Server 2005 Database Engine Tuning Advisor (DTA) aslo tune databses running on SQL 2000?”
Short answer. YES!
And in fact, something I didn’t mention at the event, but is also quite useful in the new tool; the new Database Engine Tuning Advisor (DTA) can also tune against MULTPLE databases at a time. So you’re not limited to, oh, ONE database as you were in the SQL 2000 version of the tool (Index Tuning Wizard).
Here’s a screenshot I saved that shows I’ve connected to that SQL 2000 instance, and have even selected multiple databases to tune.
(click it to see the enlarged screen capture)
Got an IT question? Give me a comment, or contact me.
Hey Kevin, did you have a chance to find out what events should be traced for the Upgrade Advisor?
No.. I haven't found the answer yet. I don't find it in the books online either. I've forwarded the question to some folks who hopefully will have an answer, and will post it as another SQL Server 2005 Tidbit soon.
Update: Got the answer. I'm going to post it as another SQL Tip.