Trace - data quantity of query results

  • I have been experimenting with creating and replaying traces for a web application - investigating some performance issues. The trace works fine, using sp_trace_create, though the sp_trace_setevent values are a bit of a mystery, but seem to work.

    Now we have identified missing indexes etc, attention is turning to the quantity of data going from SQL Server to the web application.

    Is there an easy way to find the amount of data selected, number or rows/ record sizes?

    Could it be requested in those mysterious sp_trace_setevents?

  • You could tryEXEC sp_trace_event @TraceID, 12, 48, 1

    Where @TraceID is the ID of the trace to be modified, and 48 being the column ID for the event itself (in this case RowCounts)

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • Thanks, I have been using out of date reference book, where column number only goes up to 44, looks like loads more have been added since.

    Have found the latest version now : http://technet.microsoft.com/en-us/library/ms186265.aspx 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply