SQL Server Performance Forum – Threads Archive
Trace in Query Analyzer
In Query Analyzer when i set the option of showing trace using Query menu.It showsonly the one event sp:completed .I want to get the other events also so whenever
i run the query i know which event fire and whether any recompile occurs.
Thanks
Vijay
Why not use PROFILER or server side trace to get the events.
Also check Query execution plan for more information on that query. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
In the trace it also show event for other stored procedure .I also use the
like to limit the no of proceudre monitored bu it also return event for some
other procedure.m i doing something wrong.What to set the to monitored only one procedure.
Thanks
Vijay
Using profiler you can filter by text data using the name of sp. If you have more than you want, you can filter again after trace is stoped. Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS†with no warranties for accuracy.
]]>