Troubleshooting
Problem
User runs a consolidation. This takes a long time.
Symptom
In one real-life test, the exact same (identical) virtual 16 CPU-core SQL 2008 R2 SP2 server was used (for repeated tests), but only the value of "Max Degree of Parallelism" was varied for each test:
As you can see, the higher the parallelism (0 = all/infinite) the quicker the consolidations run, although there is a 'law of diminishing returns':
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.1.1","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
swg21634615