Skip to content

Performance issues when writing to large SQL tables.

Community  Performance issues when writing to large SQL tables.
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • April 17, 2019 at 7:17 am #7643
    Anonymous
    Inactive

    We are seeing performance issues when writing to large SQL tables. Has anyone else experienced issues? Are your target SQL tables indexed/clustered? Do you regularly archive your SQL tables to enhance performance?

    April 24, 2019 at 3:00 pm #7767
    Zak Cole
    Participant

    What kind of performance issues are you seeing? We will try to see if we can help you.

    April 24, 2019 at 3:08 pm #7768
    Anonymous
    Inactive

    Millions of records are backing up in a dynamic share for sys-audit table. It is intermittent, but happens quite frequently.

    April 24, 2019 at 5:08 pm #7769
    Zak Cole
    Participant

    There are a few questions we have:
    Do you have any insert triggers in your sys_audit table in your database?
    And do you have dynamic shares set up for sys_audit table directly?

    We suggest try running multiple agents, one for sys_audit table specifically and another for other tables.

    April 25, 2019 at 5:23 am #7770
    Anonymous
    Inactive

    Thanks, I think we have already taken these steps.

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.