July 12, 2013 at 6:56 am
There's a trace I'm required to have running on all my SQL servers 24x7. This trace logs security information to a file. What I'd like to look into doing is converting this trace to an extended events session, as XEs are (supposed to be) lighter-weight than a trace.
The problem is, all my servers are running SQL2008R2, so I don't have a pretty GUI to create the XEs in, nor will I any time soon.
Does anyone know of a site or way to cross-reference a trace event to an XE? I've been trying to find one, found one query, but it requires a DMV that's not in SQL08...
Thanks,
Jason
July 12, 2013 at 7:20 am
Well, having found these two posts, and seeing as several of the events being traced are login events which are apparently not implemented in XEs, I guess I won't be converting the trace...
http://www.sqlskills.com/blogs/jonathan/converting-sql-trace-to-extended-events-in-sql-server-2012/
Ah well, still going to keep poking at XEs, they look just too useful to write-off completely...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply