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: 13146

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

Bookmark It

< Previous question : C# interview questions: - What is the difference b ...

Next question > : .NET interview questions: - What is the difference ...

Comments or Responses

Posted by: Akiii on: 6/9/2012

Everyone should watch this video....its great !

Thanks and Regards
Akiii

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.
http://www.dapfor.com/en/net-suite/net-grid/tutorial/editors

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

Good Video

Thanks
<i>Regards</i>

More Interview Questions