Checklist: Performing Weekly Performance Checks

This topic lists best practices that you should follow on a weekly basis when to avoid performance issues with a BizTalk Server system.

Steps Reference

Set database auto-growth to a fixed number

  • Database auto-growth should be set to a fixed number of megabytes instead of a percentage, especially for the MessageBox and Tracking (DTA) databases. Depending on your BizTalk Server application and throughput, the MessageBox and Tracking databases can get quite large. If auto-growth is set to a percentage, then the auto-growth can be substantial as well.

  • Ideally, the size of files supporting the file groups should be pre-allocated, and if possible, set to a static size.

Limit the events that you monitor with SQL Server Profiler

Use SQL Server Profiler to monitor only the events in which you are interested. If traces become too large, you can filter them based on the information you want, so that only a subset of the event data is collected. Monitoring too many events adds overhead to the server and the monitoring process, and can cause the trace file or trace table to grow very large, especially when the monitoring process takes place over a long period of time.

Configure message batching to increase adapter performance

  • Minimize the number of transactions performed by an adapter by combining more than one operation into a single batch.

  • Limit the batch size based on the total number of bytes in the batch, in addition to message count. For more information about limiting the batch size, see Configuring Batching to Improve Adapter Performance.

Adjust the large message threshold

To improve throughput, increase the large message threshold, which lowers the number of large messages that are buffered to disk during mapping. For more information about increasing the threshold, see How to Adjust the Message Size Threshold.

Investigate memory leaks or out-of-memory exceptions in the BizTalk Server process

Memory leaks in BizTalk processes can occur due to varied reasons. See Microsoft Knowledge Base Article How to troubleshoot a memory leak or an out-of-memory exception in the BizTalk Server process ( for information about the scenarios in which a memory leak may occur, and how to fix it.