为什么sql profiler在一次执行查询时多次跟踪跟踪？ [英] Why sql profiler tracing tracing many times while executing query in one time?

问题描述

我有启动事件sp的启动器：启动和sp：没有过滤器已完成，因为它在我的本地机器上并且没有运行其他应用程序在后台，



比我运行查询，

I have start profiler for event sp:starting and sp:Completed with no filter because it is in my local machine and no other appplications are running in background,

than I run query,

select * from HumanResources.Employee

我得到了很多sp;开始和sp：已完成的事件!!



我显示的是相同数量的跟踪表中存在记录数。



任何人都可以告诉我为什么会发生这种情况，我应该只运行一次查询。



谢谢。

and I get trace of so many sp;starting and sp:completed events!!

I thing it shows the same number of trace which are the number of records exists in table.

Can any one tell me why this happens, It should be only ones while I run query for one time.

Thanks.

推荐答案

您的查询只运行一次而不是记录次数。

i认为您应该在配置文件中开始新跟踪之前检查事件选择属性。选择你要跟踪的那些事件。

Your query will run only once and not for the number of records times.
i think you should check event selection properties before starting a new trace in profile. Choose oly those events which you want to trace.

这篇关于为什么sql profiler在一次执行查询时多次跟踪跟踪？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！