What are events SQL profiler eventclass numbers 65527,65528,65533,65534

I’ve been trying to use RML to process some files and couldn’t figure out why the numbers where all so much smaller than they should be. I then found a line in the RML output

“Found [TRACE_STOP] event indicating the end of the trace files”

This causes RML to stop processing further data, oh.

In my case I had stopped the trace to add some error events because the client was experiencing errors.

How do I get RML to process all the other data I wondered. This lead me to the eventclasses in the trace data which I had loaded directly into a table for detailed analysis (RML doesn’t give you exact statements).

This gave me the following eventclasses 10,12,13,17,33,65527,65528,65533,65534. I can explain the first 5 but not the 655** ones.

THis one post gave me an idea of what they where and so I did some digging http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/ddb8691a-7a46-4c56-b5e1-ed3407482cce/

From my analysis this is what they are

65534 Trace start
65528 First file in trace sequence, seems to appear after all the existing connections events. A bit like this is the start of the live events.
65527 Trace Rollover (i.e. a new file has been started
65533 Trace Stop

How does that help me well I can remove the Trace Stop and Start events I don’t want load the trace data in profiler and then save back to a file and have RML process it. Very painful but the only option I can think of.

Published 11 June 2010 08:09 by simonsabin

Comments

11 June 2010 09:23 by SimonS Blog on SQL Server Stuff

# What are events SQL profiler eventclass numbers 65527,65528,65533,65534

I’ve been trying to use RML to process some files and couldn’t figure out why the numbers where all so

30 August 2012 18:52 by Misc Links for Aug 29,2012 | SQLAndy

# Misc Links for Aug 29,2012 | SQLAndy

Pingback from  Misc Links for Aug 29,2012 | SQLAndy