测试存储过程的性能

我对表进行了一些操作，以便针对使用有问题的SP的Web服务方法上的超时问题更快地进行SP操作.

I did some operations on my tables to get faster SP operations against to time-out problem on a web service method which uses that problematic SP.

我试图比较SP的性能，但是我不能很好地解决这一问题.请参阅 1 .

I was trying to compare SP perfomance but i could not get on well on that sie. See 1 please.

很显然，我想看看在对开发范围进行所有SP修改后是否遇到超时问题.如果一切顺利，我将把新索引放入PRODUCTION ENVIRONMENT，该索引对SP可以更快地解决超时问题.

Clearly, I want to see if I get time-out problem after all SP modifications on development scope. If everything goes well, I will put my new indexes to PRODUCTION ENVIRONMENT, the indexes which helps the SP to run faster against to time-out problem.

1-如何确定Web.Config文件确实可以让SP自行运行，直到操作成功完成.这种配置足够吗?

1- How can I be sure Web.Config file does let the SP run itself until the operation will be completed successfully. this configuration eneough ?

<configuration>

<location path="~/WebService.asmx">

<system.web>

<httpRuntime timeout="700"/>

</system.web>

</location>

</configuration>

或者，我应该在超时时间内编辑连接字符串吗?

OR, Should i edit the connection string for time-out duration?

Connect Timeout=30

问候BK

参考:

比较SP性能

Nina:SQL论坛分析器结果我如何看待Profiler ..的结果?替代文字http://www.freeimagehosting.net/uploads/8a7925c767.jpg