Running DTA for Index recommendations

• khunkardba

  Newbie

  Points: 7

  More actions

  February 21, 2012 at 5:50 pm

  #268679

  Hi Friends,

  I am trying to get index recommendations for a database. However it is giving me drop index scripts and no create scripts. How do we chose the work load table when we chose a whole database? Can some body please let me know how we can chose.

  Also how do we create index on a particular database on all tables. I mean what is the basis? How do we select clustered and non clustered. Please let me know.

  Thank you all!

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  February 21, 2012 at 6:22 pm

  #1450044

  Try reading this to see if helps.

  http://msdn.microsoft.com/en-us/library/ms345524(v=sql.100).aspx

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]