5

I have inserted data from a sql trace in a table and I have a problem interpreting the data in table.

In the attached image the reads related to my SP are very low but on the next line for a value of NULL in Text Data column the reads are very high.

How do i interpret this.? Why the NULL rows have so high read values?

Edit: I have updated the image file. Now it has all the column names for initial 10 rows of my trace I could not find any EventType column, but there is an EventClass column which has value : 15 for every NULL row.

Screenshot

Profiler Screenshot

Community
  • 1
  • 1
Pawan Pillai
  • 1,955
  • 5
  • 37
  • 64

1 Answers1

7

Check out the SQL Server Event Class reference. You determine the EventType by EventClass value. Some EventClass types come with a NULL value for TextData.

Also, here's a query that might help you out mapping the EventClass ID to the actual event type:

SELECT   te.name
FROM     dbo.Trace t 
         JOIN sys.trace_events te ON t.EventClass = te.trace_event_id

where dbo.Trace is the table where you save the EventClass values.

TheBoyan
  • 6,802
  • 3
  • 45
  • 61
  • 1
    `select * from sys.trace_events where trace_event_id=15` indicates this event is `Audit Logout` so this is [just cumulative total of reads for the connection](http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/b3ef2174-a6be-4bb1-9f6d-1568cd3a2c78/) – Martin Smith Dec 22 '11 at 20:06
  • @MartinSmith - Seems that way, yes. Although, I couldn't find what EventClass 0 and 9999 are. – TheBoyan Dec 22 '11 at 20:09
  • Maybe "Trace Start" and "Existing Connections"? Not sure what UI the OP is using that shows numbers rather than text descriptions. – Martin Smith Dec 22 '11 at 20:13