项目中调试SQLServer 方便的查看SQL语句的执行时间的方法

第一种方法， 先记录执行前的时间，然后在记录执行Sql后的时间，然后做减法 1 第一种方法： 2 declare @begin_date datetime 3 declare @end_date datetime 4 select @begin_date = getdate() 5 SELECT COUNT( 1 ) 6 -- 要执行的SQL语句 7 FROM [dbo].[DT_CV

第一种方法，先记录执行前的时间，然后在记录执行Sql后的时间，然后做减法

<span> 1</span> <span>第一种方法：
</span><span> 2</span> <span>declare @begin_date datetime 
</span><span> 3</span> <span>declare @end_date datetime 
</span><span> 4</span> <span>select</span> @begin_date =<span> getdate() 
</span><span> 5</span> SELECT COUNT(<span>1</span><span>)
</span><span> 6</span> --<span>要执行的SQL语句
</span><span> 7</span> <span>  FROM [dbo].[DT_CVPrice]
</span><span> 8</span>   WHERE  DCVP_CharacterGUID = <span>'</span><span>3434343</span><span>'</span>
<span> 9</span>   ----------
<span>10</span>   <span>select</span> @end_date =<span> getdate() 
</span><span>11</span> <span>select</span> datediff(ms,@begin_date,@end_date) <span>as</span> <span>'</span><span>用时/毫秒</span><span>'</span> 

第二种方法，将执行每个语句时采取的步骤作为行集返回，通过层次结构树的形式展示出来 

<span> 1</span> <span>set</span><span> statistics profile on 
</span><span> 2</span> <span>set</span><span> statistics io on 
</span><span> 3</span> <span>set</span><span> statistics time on 
</span><span> 4</span> <span>go 
</span><span> 5</span> --<span>写SQL语句的地方
</span><span> 6</span> SELECT *<span> FROM [dbo].[DT_CVPrice]
</span><span> 7</span> 
<span> 8</span> 
<span> 9</span> <span>go 
</span><span>10</span> <span>set</span><span> statistics profile off 
</span><span>11</span> <span>set</span><span> statistics io off 
</span><span>12</span> <span>set</span> statistics time off 

 

第2个方法效果如下图，

 

第三种方法 ，用Sql Server 自带的工具

位置：工具》选项》查询执行》高级

 

 

效果如图，