Hello everyone, I want guidance on what events may I select and what “Column Filters” may I apply in SQL Server Profiler so that I see only the queries from my particular NAV Service on the SQL Server in a Trace.
My problem is that I see a lot of Event classes when I run the trace without any specific event selections and filters. I have to find the queries which I am concerned about in between all these Event Classes.
Any help would be great!
Thanks,
Ishwar
I’m not sure if it can be called guidance but this is what I usually do:
- start sql profiler with default events and output to a table (start the trace - run your NAV RTC task - stop the trace)
- query the new table (TextData) field for specific keywords,tables, databases - you guess are the culprit.
The only column filter I can see is for LoginName to be the user under which your nav service runs.
As per events, RPC:Completed seems to be the one we are interested in for executed queries, views, or sp.
In other instances I ran a query in in SSMS to determine the currently running queries.
This approach was useful in one upgrade project where by running one task (transfer data) from upgrade Page 104002 the task would not finish because of some faulty data in our AddOn.
Hope it helps!