查看系统日志
select * from sys.traces
查看sql profile转储文件
- 先要用sql profile监控数据库,导出成trc
- 拷贝至数据库服务器上,eg.d:\sqldata\trace\201611290881.trc
- sql查询中如下语句查看
--SELECT cpu,TextData,Reads,Writes
SELECT *
FROM ::fn_trace_gettable('d:\sqldata\trace\201611290881.trc',default)
WHERE SPID > 50
and StartTime > '2016-11-29 11:30:00.000'
AND cpu > 100
SELECT *
FROM ::fn_trace_gettable('d:\sqldata\trace\201611290881.trc',default)
WHERE SPID > 50
and StartTime > '2016-11-29 11:30:00.000'
AND cpu > 100
ORDER BY cpu DESC
--查看trace文件里内容
select *
from fn_trace_gettable('C:\a.trc',0)
where HostName='SIT1_WIN_API'
order by reads desc
执行统计功能
打开统计功能 set statistics io on
执行具体sql语句
消息中可以看到具体执行情况