create proc sp_test @nMillionSecond1 int output, @nMillionSecond2 int output as begin declare @dt datetime --query 1 set @dt=getdate() select * from sysobjects set @nMillionSecond1=datediff(ms, @dt, getdate()) --query 2 set @dt=getdate() select * from sysobjects set @nMillionSecond2=datediff(ms, @dt, getdate())end go
SQL 2005 的性能工具中有个SQL Server Profiler的监视工具, 可以满足楼主的需要
将sp里面的query,单个放在查询分析器里面查看执行计划
@nMillionSecond1 int output,
@nMillionSecond2 int output
as
begin
declare @dt datetime --query 1
set @dt=getdate()
select * from sysobjects
set @nMillionSecond1=datediff(ms, @dt, getdate()) --query 2
set @dt=getdate()
select * from sysobjects
set @nMillionSecond2=datediff(ms, @dt, getdate())end
go
可以满足楼主的需要