If a concurrency bottleneck had occurred on the item tables, increasing
the number of them will in turn increase the throughput of the messaging engine.
Procedure
- Relevant performance monitoring tools show that the throughput
of a messaging engine is insufficient.
- Use your database performance monitoring tools to examine lock
statistics for the item tables for evidence of a bottleneck. Consult your
database documentation on how to interpret the locking statistics.
- Increase the attributes for the messaging engine’s data store: the number of permanent
tables or temporary tables, or both. For more information see Configuring a messaging engine to use a data source. You can only increase the number of permanent tables or temporary tables,
not decrease them.
- Stop and restart the messaging engine so
that configuration changes take effect. The extra tables are created when
the messaging engine starts again.
- Observe the effect on throughput and lock statistics by checking
performance monitoring tools. Consider whether any improvement is sufficient
and modifying the data store attributes
further would be beneficial