Profiler trace

Last Post 23 Nov 2011 05:35 AM by darko_73. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
darko_73
New Member
New Member

--
23 Nov 2011 05:35 AM
Hi,
I am running two traces:
1.RPC Completed and SQL BatchCompleted
Columns:EventClass, TextData, ApplicationName, LoginName, Duration and StartTime
Filter: Duration > 4000

2.RPC Completed and SQL BatchCompleted
Columns:EventClass, TextData, ApplicationName, LoginName, HostName and StartTime
Filter: TextData like %delete% and %update%.

Both run fine if I start them manually. I am getting statements that run longer than 4 seconds and for 
the socond one I am getting only update and delete statements.
When I run them through sql agent as a job the second trace is returning me everything - all statments 
insckuding select. What can cause this problem?

Thanks


You are not authorized to post a reply.

Acceptable Use Policy