index tuning wizard

• jessica-321853

  SSCrazy

  Points: 2207

  More actions

  January 17, 2007 at 8:52 am

  #117067

  hi guys i am trying to run the index tuning wizard from sql profiler but sql server analyzer option is not available why?

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  January 18, 2007 at 7:31 am

  #683996

  I'd suggest you don't - the sql2k wizard is essentially rubbish. If you really must use one of these tools run it aginst the sql 2005 tuning advisor.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/

• jessica-321853

  SSCrazy

  Points: 2207

  More actions

  January 18, 2007 at 7:48 am

  #684002

  but i don't have sql server 2005, i have sql server 2000. what do i do?

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 18, 2007 at 4:55 pm

  #684153

  You can download trial version and use it.

  Microsoft SQL Server 2005 Enterprise Evaluation Edition

  http://www.microsoft.com/downloads/details.aspx?familyid=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en

   

  SQL Server 2005 Books Online 

  New Database Engine Tuning Advisor 

  http://msdn2.microsoft.com/en-us/library/ms170735.aspx

   

  MohammedU
  Microsoft SQL Server MVP