SQL Server Performance Forum – Threads Archive
Trace in Query AnalyzerIn Query Analyzer when i set the option of showing trace using Query menu.It shows
only 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.
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
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.
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
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.