The sum of all SQL Server matter that exist,
and the space in which all SQL Server events
occur or could occur.
Welcome to SQL Server Universe.com Sign in | Join | Help
in
Home SS SLUG Forums Articles Photos Downloads
SQL Server Universe.com » SQL Server Components » T-SQL » Index Tuning Wizard Problem [:(]

Index Tuning Wizard Problem [:(]

Last post 10-19-2007, 3:04 by Dinesh Priyankara. 1 replies.
Sort Posts: Previous

  • Index Tuning Wizard Problem [:(]

    		 10-19-2007, 2:31

    lucki
    • Joined on 10-17-2007
    • Posts 6
    • Points 0
    • Top 25 Contributor
    Reply Quote

    I want to know whether a Index Tuning Wizard is available in Sql Sever 2005?If so can u plz give me instructions how to access it?

     

  • Re: Index Tuning Wizard Problem [:(]

    		 10-19-2007, 3:04

    Dinesh Priyankara
    • Joined on 11-22-2006
    • Colombo, Sri Lanka
    • Posts 102
    • Points 0
    • Top 10 Contributor
      Male
    Reply Quote
    Hi,

    It is available as Database Engine Tuning Wizard. The link for the application available under the Tools menu of SSMS. If you need to check for selected query, highlight it and right click on it, click on the Analyze Query in Database Tuning Wizard menu item.

    We had covered this tool with one of sessions we did for SS SLUG; if need to see the presentation, go to download page and download the content for M02D02 Overseeing Indexes - Presentation.

    Please let me know if you need more info.
View as RSS news feed in XML

(Best viewed with a resolution of more than 1024 * 768)
Powered by Community Server, by Telligent Systems