Improve SQL Server performance using profiler and tuning advisor

Profiler:- This is one of main tools provided by SQL Server, which is mainly used to capture the events in SQL Server.

Profiler and Database tuning advisor are inbuilt tools in SQL Server. which mainly used to improving performance of a SQL Server..

In this video...we will see how to improve the performance of table..
1. First we have to capture all the events  which are running in a specific db by using profiler.
2. Then  open DTA and provide " .trc " file as a input and specify the db  and then run the start analysis process..
3 Then the DTA will analize the profiler input and will provide recommendations which includes index and statistics.