在数据库中分析sql执行性能 

SET STATISTICS PROFILE ON 
SET STATISTICS IO ON 
SET STATISTICS TIME ON 
GO 
/*--SQL脚本开始*/
SELECT * FROM dbo.Table
GO 
/*--SQL脚本结束*/
SET STATISTICS PROFILE OFF 
SET STATISTICS IO OFF 
SET STATISTICS TIME OFF

 

posted @ 2015-01-18 22:16  astrue  阅读(286)  评论(0)  编辑  收藏  举报