sys_transaction_pattern Table is Not in Sync With The syslog_transaction TableIssue I'm comparing data from the transactions log to the slow transaction table and I'm seeing inconsistencies in the metrics gather in the slow transaction table vs the transaction table. I'm trying to get a better understanding as to why the metrics in slow transactions doesnt reflect the actual data in the transaction log and hence showing inaccurate information.Cause The sys_transaction_pattern table is not in sync with the syslog_transaction table, below are the justification behind it: 1) syslog_transaction table OOTB only holds up around 44 or 45 days of log history where its never gonna be in sync with the sys_transaction_pattern since the sys_transaction_pattern table will have the info from the moment the sys_transaction_pattern first kicks off and then finds its first finding of slow transaction, which could be long before 44 days. 2) Even if you deleted some of the records from the sys_transaction_pattern table where when it re-initiates and again finds its first occurrence of slow transactions, still the counts or average execution time still is not in sync with whats already on the syslog_transaction table, and that is because sometimes the same type of transaction does not always run slow and if its not slow, it wont be captured on the sys_transaction_pattern table. Resolution As a result, because of what I mentioned above, you should treat the sys_transaction_pattern more as an estimate and if you want a more accurate estimate, you should delete all the data from the sys_transaction_pattern table so it then regenerates with more up to date information to make it more accurate, but it wont be 100% in sync with the syslog_transaction table, however it will be a more accurate estimate than having data from years back.