How can we improve SQL performance using SQL profiler?

Answer:

 
By using SQL profiler we can capture the load and then feed that load to SQL Server tuning advisor. Tuning advisor scans the load and then gives out index suggestions.