Chris,
There is some performance overhead for RAT capture. The performance
overhead of capture depends on the workload. The overhead is proportional
to the amount of data sent from the client, and the SQL statements being
run during the workload capture. In our case, the overhead for RAT capture
was ~3%, but this may vary in your case, depending on your workload.
You can probably test it in your staging/QA database first, and observe the
overhead before going to production.
Hope this helps.
Thanks,
--Qaiser
On Wed, Aug 9, 2017 at 12:49 PM, Chris Taylor <
christopherdtaylor1994@xxxxxxxxx> wrote:
Is there any additional load on the Prod db if you're capturing workloads
to replay on another database?
Let's say our Prod box is CPU bound (severely) - would RAT worsen that, or
does it somehow manage to capture the workloads without adding additional
load the source server? I'm guessing it does but want to confirm.
Chris
