Click here to Skip to main content
15,868,049 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
hi,

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,

SQL
select * from HumanResources.Employee


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.
Posted

1 solution

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.
 
Share this answer
 
Comments
ExpertITM 24-Jan-13 12:13pm    
Hi,

I have already select sp:stating and sp:completed event, but when I run the above query for one time ant it shows the large number of traces.
Why this??

Thanks.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900