Improve SQL Server performance using profiler and tuning advisor

These videos shows a simple explanation of what is a SQL server profiler and performance tuning wizard.