Share via

SQL Server 2005 Tidbit 037

  • Article

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.

Comments

  • Anonymous
    December 01, 2005
    Hey Kevin, did you have a chance to find out what events should be traced for the Upgrade Advisor?
  • Anonymous
    December 02, 2005
    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.
  • Anonymous
    December 05, 2005
    Update: Got the answer. I'm going to post it as another SQL Tip.

    Thanks!