Post utilization timers output shows times spent on shareplex_trans table is significant and there are many rows in shareplex_trans table on target.
Lots of executions on shareplex_trans table
WORKAROUND:
1. Stop post
2. Pin shareplex_trans table in the keep buffer pool
alter table shareplex_trans storage (buffer_pool keep);
3. start post
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center