Increasing the number of item tables for a messaging engine when tables are automatically created
If a concurrency bottleneck occurs on the item tables, increasing the number of items tables will increase the throughput of the messaging engine. Before performing this task verify the messaging engine is using a data store, and that its Create tables option is set to True.
- Relevant performance monitoring tools show that the throughput of a messaging engine is insufficient.
- Use the database performance monitoring tools to examine lock statistics for the item tables for evidence of a bottleneck. Consult the database documentation on how to interpret the locking statistics.
- Increase the attributes for the messaging engine data store: the number of permanent tables or temporary tables, or both.
See see Configure a messaging engine data store to use a data source. We 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
Last updated Nov 10, 2010 8:23:07 PM CST