开发者

What values need to be least selected to optimize indexes with database engine tuning advisor

For MSSQL 2008 R2 database what values need t开发者_如何学Co be selected minimum to find required indexes when profiler trace given to the database engine tuning advisor ?

These are the values that can be selected at profiler

http://img40.imageshack.us/img40/5274/minimumy.png

I need to select lowest possible variable to record because profiler will run on product environment. I want database engine tuning advisor to find necessary indexes from this profiler recorded trace. So minimum which checkboxes need to be checked.


If you want to feed your trace data into the Database Tuning Advisor, your best bet is to select the "Tuning" template in the trace properties dialog. This will set all of those selections for you and provide a trace that the DTA can use.

What values need to be least selected to optimize indexes with database engine tuning advisor

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜