If on sql server, its Query Analyzer has an option called "Analyze query execution plan" which shows you how the query (storedproc) is going to be executed.
【在 d******e 的大作中提到】 : tell us your databse Managerment system. : 不知道具体的dbms怎么帮你 : 并且,你可以检查的东西太多,index,i/o,存储过程的个数. : 操作系统,cooked file or raw disk.参考一下你的performance guidance吧.
d*e
5 楼
oh,对mS的东西不太懂.不过你先看看性能的各种数据.
【在 h*****l 的大作中提到】 : My DBMS is MS SQL Server.
l*w
6 楼
what version, 2000 or 7.0. There are perf tools come with the installation. I will give you more detail tomorrow after I check some references.
【在 h*****l 的大作中提到】 : My DBMS is MS SQL Server.
l*w
7 楼
using sql profiler you can find out the time spend on each statement.
【在 l*w 的大作中提到】 : what version, 2000 or 7.0. There are perf tools come with the installation. : I will give you more detail tomorrow after I check some references.