Part 4: Performance Tuning
The chapters in Part 4 provide information to help you tune your SQL Server database:
Performance Tuning
Index Tuning Wizard
Send feedback
to MSDN.
Look here
for MSDN Online resources.