053-412

Performance divergence indicated in the Workload Replay report is most likely due to what?
A. DML and SQL statement results that do not match between the capture and replay systems
B. When errors that occur in the capture system dont occur in the replay system
C. Top SQL statements
D. Infrastructure or system-configuration differences
E. Time-of-day differences between capture and replay systems

  Option A is incorrect;DML and SQL results drive data divergence.Option B is incorrect because error divergence,not performance divergence,happens when errors that occur in the capture system don't occur in the replay system.Top SQL statements should behave the same in the capture and replay systems,unless there is a data-divergence issue,so C is incorrect.E is incorrect because the time of day should have no impact on differences between the capture and replay systems.It is possible that other workloads running on the capture and replay systems that have a time-of -day trend might impace performance,but that is an extraneous variable,not a cause.

posted @ 2017-11-14 11:38  巴啦啦大魔王  阅读(139)  评论(0编辑  收藏  举报