Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Optimizing Databases > Database Engine Tuning Advisor (DTA)

Database Engine Tuning Advisor (DTA)

For a complex database with dozens or hundreds of tables, it isn’t so easy to identify the best indexes to create. The Database Engine Tuning Advisor (DTA) can be used to provide a little more science to this monumental task.

The DTA replaces the Index Tuning wizard from SQL Server 2000. It can be used to:


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint