Scenario Properties Profiling Options Tab (XQuery)

Click the Profiling Options tab to turn on the Profiler and to specify the type of information you want to capture in the Profiler's report.

Fields

Show Call Tree of Execution Times

Displays the Call Tree section of the Profiler report, which lists the call tree of XQuery instructions. Duplicate instructions within individual call tree paths are not repeated. The report's Call column identifies the number of times a given instruction is called within each call tree.

Show Execution Time by XQuery Instruction

Displays the Node Summary section of the Profiler report, which lists every instruction that is called by the XQuery code. Instructions are listed only once, regardless of the number of times they are called. The report's Call column identifies the number of times an instruction is called.

Show Log of Step-by-Step Execution

Displays the Event Log section of the Profiler report, which lists every instruction that is executed in every call tree, regardless of the number of times it is called. Displaying the report with this option selected can, therefore, take a long time. The XQuery processing time itself is not affected by this report option.

Limit Trace To

Displaying a Profiler report can often take much longer than the time required to evaluate the XQuery itself. You can use the Instructions and Levels field in the Limit Trace To group box to limit the number of instructions and/or the depth of the levels displayed.

Save Raw XML Profiling Data To:

Saves the raw performance data captured by the Profiler to an XML file. Use this option if you want to create your own reports.

For More Information