![]() |
#2
cnfarer2010-07-07 10:59
|
情况是这样的:在SQL SERVER2005中连接一个远程服务器的数据库后发送一个查询的QUERY
SET STATISTICS TIME ON
SET STATISTICS IO on
go
select * from dbo.v_tcm_billing_history as s
where CONVERT(DATETIME,s.billingTime) > '6/9/2010'
and convert(datetime,s.billingtime)<'7/6/2010'
and s.fair >= 0 order by receiptId
返回的信息里面有一项是SQL EXECUTION TIME: CPU TIME=XXX ms,ELAPSED TIME=XXX ms,我想知道这个elapsed time究竟指的是从本机发送query到本机从网络上收到查询结果的时间 还是指 服务器端执行SQL语句到服务器完成查询得到查询结果的时间
请各位大大指点迷津!~~