000030702 - Improve RSA Archer Performance with more frequent DB Reindex

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Mar 13, 2019
Version 5Show Document
  • View in full screen mode

Article Content

Article Number000030702
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer
RSA Version/Condition: 5.x 6x
Product Description: Archer Platform
IssueSystem is slow. DB Server CPU intermittently 100%.
TasksReindex tables to increase performance.
ResolutionThere is a job, "RSA Archer Database Index Rebuild", that can help performance. Editing it will allow it to run more frequently.
  1. In SQL go to SQL Server Agent
  2. Under Jobs choose RSA Archer Index Rebuild*
       *   if it is not there, deploy first via the Program Files/RSAArcher/Tools/jobDeployScript.sql
    User-added image
  3. Right-click, Properties
    User-added image

  • Edit Schedules.
    User-added image

  • Change weekly to Daily