PRB: SQL 2000 Profiler Doesn't Capture SHOWPLAN Events if the BinaryData Data Column Is Not Captured (272439)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q272439

SYMPTOMS

When using the SQL Server 2000 Profiler to capture the SHOWPLAN event classes from the Performance event category, if the BinaryData data column is not captured, these events are captured but with no data in them.

WORKAROUND

Select the BinaryData data column in the profiler trace to ensure that these events are captured with the correct data.

MORE INFORMATION

The following event classes from the Performance event category are dependent on the BinaryData data column:
  • Show Plan All: Displays the query plan with full compile-time details (for example, costing estimates and column lists) of the SQL statement being executed.
  • Show Plan Statistics: Displays the query plan with full run-time details (including actual number of rows passing through each operation) of the SQL statement that was executed.
  • Show Plan Text: Displays the query plan tree of the SQL statement being executed.
Modification Type:MinorLast Reviewed:3/18/2004
Keywords:kbpending kbprb KB272439
©2004 Microsoft Corporation. All rights reserved.