![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsISPrdEZwZ1Rh5WNXp1bwNjW1ZUba9VZwlHdsATOfd3bkFGazxCMx8VesATMfhHLlN3XnxCMwEzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5CMyMmN4YTZmJWY5kTM1kjZkVGZkRWZwMmMiZ2YkZTNy8CX5AzLchDMxIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjL0M3Lc9CX6MHc0RHaiojIsJye.png)
添加三个选项:
下一步就可以了
Sql跟踪的模板:
跟踪Sql 语句的执行情况:
使用刚才的新建的模板:
用到的Sql语句:
select * from [Sales].[SalesOrderDetail]
select * from [Sales].[SalesOrderDetail] where LineTotal>2000
select * from Production.Product
select p.Name,s.orderqty,s.linetotal from Sales.SalesOrderDetail as s inner join
Production.Product as p on p.ProductID=s.ProductID
停止Profiler 在停止性能监视器
导入性能数据