Using Extended Events to Performance Tune Sage 500 - Part 5
Add helper columns to the XE table
In this point of the series, I am assuming that you have followed parts 1 through 4 and have an Extended Events trace table in a test or development environment that you are setting up for analysis. Part 5 adds helper columns to this data for the analysis and an additional table used to aggregate the data for each activity_id in a single script. I’ve explained each step in the comments for the step. Also note that I have a full blog post explaining what is happening in Step 6.
More in this Troubleshooting series
GOT QUESTIONS ABOUT Sage 500 ERP?
Contact us if you have more questions about your Sage 500 solution >> Contact RKL eSolutions