Click here to Skip to main content
12,757,627 members (37,202 online)
Rate this:
 
Please Sign up or sign in to vote.
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,

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 23-Jan-13 7:12am
ExpertITM1.4K

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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.
  Permalink  
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)

    Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.170217.1 | Last Updated 24 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100