Sample Header Ad - 728x90

How to index of filter extended event files in Sql Server

1 vote
1 answer
220 views
I am collecting errors data using the error_reported event and saving the data on XEL files. The problem is that there are hundreds of thousands of errors over there and querying them can take a lot of time. One option is to prevent errors from being logged twice if they happened on the same object in the same timestamp. I really don't think the second option is possible. Second option is to index the file in a way that it will be quick to filter errors by the error text and the object that caused them. So far I thought of creating a separate process that will run in the background and writes filtered values from the files to an indexed table, but its a bad solution. That process would need maintenance and could be expensive on IO resources. So far I didn't find a way to solve it on the extended event level. Does anyone have a better idea?
Asked by Yuval Perelman (111 rep)
Oct 28, 2018, 04:59 PM
Last activity: Jun 12, 2025, 02:01 AM