000030702 - Improve Archer Performance with DB Reindex

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 4Show 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
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 use of the latest version.
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
4) Steps, Edit
User-added image
5) Change exec usp_reindex_db to exec usp_reindex_db_2, ok
User-added image
6) Edit Schedules
User-added image
7) Change weekly to Daily