What are the recommended values for maximum threads in the IBM TRIRIGA Admin Console > Thread Manager page? I need to set up maximum threads for better performance without causing problems to my system.
To control the number of threads that are started for each agent, use the Threads Manager menu in the IBM TRIRIGA Administrator Console. A single thread requires one connection to the database. A large value for the total of maximum threads can slow performance. As a guideline, a typical limit is no more than 2 to 3 times the core count of the database server. One must also add the number of servers and agents connected to the database.
If there are multiple Workflow Agents running against the same database, the sum total threads across all servers should not be more than 2 to 3 times the total core count of the database. As a reminder, the only scenario recommended for having multiple Workflow Agent instances running is when you have a User List associated to them. See more information in this wiki page: When to use Multiple Workflow Agents. For example, if the database has two Dual Core Xeon CPUs, the core CPU count is four (4 CPUs). So, you should have up to 12 threads connecting to the database (3 x 4 CPUs).
However, you have only a process server with a single Workflow Agent instance running as part of your topology. As such, you may share the 12 threads in this way when setting the Maximum Threads in the IBM TRIRIGA Admin Console > Threads Manager:
- CAD Integrator: 2
- Data Import Agent: 2
- Scheduler Agent: 2
- Workflow Agent: 4
- Report Queue Agent: 2
[Admin: This post is related to the 05.06.15 post about when to use multiple workflow agents.]