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.
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.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)