Video Tip:- Improve SQL Server performance by using SQL server profiler
5.00/5 (4 votes)
If you want to quickly get index suggestions and improve performance in SQL Server, then Profiler and tuning wizard is the first place to start.
Many times, developers think hard on which columns to create clustered indexes and non-clustered indexes. Below is a quick video tip which will help you get index suggestions using profiler and tuning advisor.
http://youtu.be/AaPaIVI-yyI?hd=1[^]
It's a 3 step process:
- Get your load file using the SQL server profiler.
- Pass this load file to the tuning advisor.
- Finally implement the suggestion given by tuning advisor using your own thought process.
Do watch the above video for full practical details.
For further reading do watch the below interview preparation videos and step by step video series.