Kevin Remde's IT Pro Weblog

SQL Server 2005 Tidbit 037

SQL Server 2005 Tidbit 037

  • Comments 3
  • Likes

SQL Server 2005 Tidbit 037

American_chopper

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.

DETA Example

(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?

  • Hi Steve,
    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.

    Thanks!

Blog - Post Feedback Form(CAPTCHA)
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment