1.获取自己的查询计划
set showplan on
set statistics io on
set statistics time on
set showplan,noexec on
2.临时获取别人当前正执行的查询计划和SQL文本
sp_who
sp_lock
dbcc traceon(3604)
dbcc sqltext(spid)
sp_showplan spid,null,null,null
1.获取自己的查询计划
set showplan on
set statistics io on
set statistics time on
set showplan,noexec on
2.临时获取别人当前正执行的查询计划和SQL文本
sp_who
sp_lock
dbcc traceon(3604)
dbcc sqltext(spid)
sp_showplan spid,null,null,null