Data Replication 2
Results 1 to 2 of 2

Thread: Redshift Target High CPU utilization.

  1. #1
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    297
    Rep Power
    6

    Redshift Target High CPU utilization.

    Question:
    We are replicating data from Oracle and SQL to Redshift Cluster, everything is working.

    However on Redshift Cluster Performance status we see high CPU usage of 40% or more on Attunity Insert/Update.

    Since, we have lots of activity on our Source DB, we do not want to replicate to Redshift immediately, is there a way to slow down the Insert/Update?

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    297
    Rep Power
    6
    You can change how Replicate handle change processing

    Under Task Design / Task Setting

    Change Processing / Change Processing Tuning

    "longer than" choose a higher number , say from 1 change to 60 seconds.
    "but less than"- choose a higher number , say from 30 change to 240 seconds.
    "force apply a batch when processing memory exceeds" to a higher number, say from 500 MB to 1000 MB.
    Uncheck the "limit the of changes applied per change processing statement to" , if it is checked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •