SQL Server interview questions: - How can we improve SQL performance using SQL profiler?

 Posted by Articlesmaint on 10/12/2011 | Category: Sql Server Interview questions | Views: 9645

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.

Below is a simple video which explains the same in depth.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Akiii on: 6/9/2012
Everyone should watch this video....its great !

Thanks and Regards
Posted by: Kianurieves on: 9/21/2012
The first important option which can be used for a speed optimization is the TABSQuery.RequestLive property.
If selection query is simple and involves a single table only, try to set RequestLive value to True and to False before opening a query. Some queries run faster with the RequestLive=True, others will perform much better with the RequestLive=False.

Posted by: Chakravarthi on: 9/24/2013 | Points: 10
Good Video


Login to post response