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.