阅读背景:

查询分析器VS.查询分析器读取,写入和持续时间的重复

来源:互联网 

I'm using MS Sql Server 2000, and for many queries when I run a query in Query Analyzer, with the statistics turned on, the numbers reported in the statistics tab are extremely different from the values shown in the Query Profiler. When the profiler and the analyzer are running at the same time, some queries report 200 reads in Analyzer, while the Profiler reports that the query preforms 14000 reads. Based on query performance, it appears to me that the Profiler is right. However, why is there such a large discrepancy between the two? Does anybody else have experience with the same thing occuring?I'm using MS Sql Server 2000, and for many quer




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: