Skip to content

Performance issues when writing to large SQL tables.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #7643

    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?

    #7767
    Connie SuConnie Su
    Participant

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

    #7768

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

    #7769
    Connie SuConnie Su
    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.

    #7770

    Thanks, I think we have already taken these steps.

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