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.