https://www.insidesql.org/blogs/andreaswolter/?disp=comments en-EU http://backend.userland.com/rss 60 Tue, 20 Oct 2015 10:05:36 +0000 Ashish [Visitor] c8291@https://www.insidesql.org/blogs/ Hello Andreas Wolter, Thank you very much for the reply.I tried using the file_offset and the event date and time and it worked. https://www.insidesql.org/blogs/andreaswolter/2013/06/extended-event-file-target-size#c8291 Sat, 17 Oct 2015 12:31:57 +0000 andreaswolter [Member] c8290@https://www.insidesql.org/blogs/ Hello Ashish, file_offset should be correct to use. I haven't tested it lately though and I know in the beginning there was a bug. But that should be fixed, so I would that that. What I do for my deadlock-collector, is having a hash over a couple of columns + of course the event date and time. https://www.insidesql.org/blogs/andreaswolter/2013/06/extended-event-file-target-size#c8290 Thu, 15 Oct 2015 13:11:48 +0000 Ashish [Visitor] c8288@https://www.insidesql.org/blogs/ Hi Sir, currently i am working on the enhancement for MS SQL for event monitoring. The requirement is that We used to monitor events from the SQL server trace initially. Now we have to migrate to Extended event file(.xel). we use to query trace table to get the event data. There it used to keep the track of the row number in order to fetch the data next time after that row. Since Extended events are in file i cant use the same query to get the data from the file. I have query that get data from the file but there is no field that tell me that i have already read this data(like column number from table,there i can query WHERE column > x). can you please tell me what field i can use for this. there is one column called file_offset but i dont think i can use it. Thanks. x). can you please tell me what field i can use for this. there is one column called file_offset but i dont think i can use it. Thanks.]]> https://www.insidesql.org/blogs/andreaswolter/2013/06/extended-event-file-target-size#c8288