By using SQL server profiler you can capture the load and create a load file , then this load file you can submit it to SQL Server performance tuning wizard to get performance suggestions. Below is a simple video which demonstrates end to end how SQL server performance tuning wizard helps to achieve performance.

Please click here to see more C# interview questions