Troubleshooting
Problem
Customer would like to know if there is a link between the size of the Controller application repository database and the speed/performance of Controller.
Symptom
Customer is experiencing slow performance in Controller, and would like to know if reducing the size (compacting) the database will help.
Example:
A typical (average) customer’s Controller SQL database (after being in production/use for a small number of years) will be approximately 10Gb to 40Gb in size
- However, the largest size of a customer’s database that the author has seen is approximately 160Gb.
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3;10.2.1;10.2.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
08 May 2025
UID
swg21681197