Database Engine Tuning Advisor

Microsoft's Database Engine Tuning Advisor is an immensely useful tool. Features include:

  • recommend indexes based on query analysis
  • analyze proposed schema changes
  • query tuning recommendations
  • customization of recommendations
  • performance reports

A tutorial is available on MSDN.