Maintaining Performance

This section provides information that is intended to help you resolve performance issues discovered during your routine maintenance checks. You can also use the tools and techniques described here proactively, to identify potential problems before they become critical issues.

You will generally need to establish a performance baseline as a standard against which to assess current system performance.

In addition to the topics in this section, other topics in this document address performance issues. These topics are listed in Related Sections below.

In This Section

• Best Practices for Maintaining Performance

• Configuring Batching to Improve Adapter Performance

• How to Adjust the Configuration Cache Refresh Interval

• How to Disable Tracking

• Troubleshooting Performance Issues3

Related Sections

• For more information about performance issues in general, see BizTalk Server Performance Optimization Guide at https://go.microsoft.com/fwlink/?LinkID=150492.

• For information about analyzing weekly performance monitor logs against baseline and thresholds, see Using the Performance Analysis of Logs (PAL) Tool, "Finding and Eliminating Bottlenecks" in the BizTalk Server Performance Optimization Guide at https://go.microsoft.com/fwlink/?LinkId=154675, and Troubleshooting Performance Issues3.

• For information about ensuring that the system is not experiencing frequent auto-growth of BizTalk Server databases, see Defining Auto-Growth Settings for Databases, "Tracking Database Sizing Guidelines" in the BizTalk Server Help at https://go.microsoft.com/fwlink/?LinkId=154677, and "Identifying Bottlenecks in the Database Tier" in the BizTalk Server Help at https://go.microsoft.com/fwlink/?LinkId=154678.

• For information about maintaining SQL Server, Performing SQL Server Maintenance Procedures.

• For information about running SQL Server Profiler during high load to check for long response times and high resource usage, see "Using SQL Server Profiler" in SQL Server Help at https://go.microsoft.com/fwlink/?LinkID=106720.

• For information about ensuring that message batching for all adapters is appropriate for resource consumption or latency, see Configuring Batching to Improve Adapter Performance.

• For information about increasing the BizTalk Server cache refresh interval, see How to Adjust the Configuration Cache Refresh Interval.

• For information about inbound and outbound host throttling, see "What is Host Throttling?" in BizTalk Server Help at https://go.microsoft.com/fwlink/?LinkId=154694. For information about triggers, actions, and mitigation strategies for inbound and outbound throttling, see "Throttling condition triggers, actions, and mitigation strategies" in BizTalk Server Help at https://go.microsoft.com/fwlink/?LinkId=154695.

• To use a PassThrough send pipeline instead of the default XML send pipeline, see "Managing Send Ports Using BizTalk Explorer" in BizTalk Server Help at https://go.microsoft.com/fwlink/?LinkID=154696.

• For information about sizing the tracking database, see "Tracking Database Sizing Guidelines" in the BizTalk Server Help at https://go.microsoft.com/fwlink/?LinkId=154677.

• For information about sizing the MessageBox, BizTalkDTADb, and BAMPrimaryImport databases, see "Identifying Bottlenecks in the Database Tier" in the BizTalk Server Help at https://go.microsoft.com/fwlink/?LinkId=154678.

• For information about avoiding contention in the MessageBox database, see How to Avoid Disk Contention (https://go.microsoft.com/fwlink/?LinkId=158809) in the BizTalk Server Performance Optimization Guide.