Recommended transaction isolation level of BizTalk Server 2002 COM+ components (834439)


The information in this article applies to:

  • Microsoft BizTalk Server 2002

SUMMARY

The transaction isolation level for all Microsoft BizTalk Server COM+ components is set to Serialized if you install Microsoft BizTalk Server 2002 on a computer that is running Microsoft Windows Server 2000.

The transaction isolation level for all BizTalk Server COM+ components is set to Serialized if you install Microsoft BizTalk Server 2002 on a computer that is running Microsoft Windows 2000 and subsequently upgrade the operating system to Microsoft Windows Server 2003 or Microsoft Windows XP.

The transaction isolation level for four of the BizTalk Server COM+ components is set to Read Committed if you install BizTalk Server 2002 on a computer that is running Windows Server 2003 or Windows XP.

If you have installed BizTalk Server 2002 on a computer that is running Windows Server 2003, Microsoft recommends that you change the transaction isolation level for the BizTalk.InterchangeStateEngineTx.1 component back to Serialized by following the instructions that are listed in the "More Information" section of this article.

Microsoft recommends the following application isolation settings for the following BizTalk Server 2002 COM+ components:

COM+ componentRecommended application isolation settingHosting COM+ application
BizTalk.InterchangeStateEngineTx.1SerializedBizTalk Server Internal Utilities
BizTalk.BTSSubmit.1Read CommittedBizTalk Server Internal Utilities
BizTalk.WrapBYOT.1Read CommittedBizTalk Server Internal Utilities
BizTalk.Interchange.1Read CommittedBizTalk Server Interchange Application
WkFlow.SysMgrSerializedXLANG Scheduler
BizTalkWorkflow.SkedDBHelper.1AnyXLANG Scheduler Persistence Helper

MORE INFORMATION

All COM+ components that are installed on Windows Server 2000 have a non-configurable transaction isolation level of Serialized. However, on Windows Server 2003, the COM+ component transaction isolation level is configurable. This behavior permits BizTalk Server 2002 Setup to change the component-level transaction isolation level from the default setting of Serialized. When you install BizTalk Server 2002 on Windows Server 2003, BizTalk Server 2002 Setup creates the BizTalk.InterchangeStateEngineTx.1 COM+ component with a default transaction isolation level of Read Committed.

To change the transaction isolation level for the BizTalk.InterchangeStateEngineTx.1 COM+ component to Serialized, follow these steps:
  1. Start the Component Services Microsoft Management Console (MMC) snap-in. To do this, click Start, point to Programs, point to Administrative Tools, and then click Component Services.
  2. Expand Computers, expand My Computer, and then expand COM+ Applications.
  3. Right-click BizTalk Server Internal Utilities COM+ application, and then click Properties.
  4. Click the Advanced tab.
  5. On the Advanced tab, click to clear the Disable changes check box, and then click OK.
  6. Expand the BizTalk Server Internal Utilities COM+ application, expand Components, right-click the BizTalk.InterchangeStateEngineTx.1 component, and then click Properties.
  7. Click the Transactions tab.
  8. On the Transactions tab, change the selected value in the Transaction Isolation Level list to Serialized, and then click OK.
  9. Repeat steps 3 through 8 for the other COM+ components that are listed in the table above as needed. As you complete steps 3, 6, and 8, substitute the appropriate values from the table in the "Summary" section of this article for any COM+ component that you are modifying.
  10. Shut down any COM+ applications that you have changed the transaction isolation level for, and then stop and restart the BizTalk Messaging Service. To shut down the COM+ application, right-click the COM+ application, and then click Shut down.

    Note If the Shut down command is not available, the COM+ application is not running. Therefore, you do not have to shut it down.

REFERENCES

For more information about how to configure COM+ transaction isolation levels, visit the following Microsoft Web site:

http://msdn.microsoft.com/library/en-us/cossdk/htm/pgservices_transactions_654j.asp

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

215520 INFO: COM+ and MTS always use SERIALIZABLE Transaction Isolation Level

Modification Type:MinorLast Reviewed:1/28/2004
Keywords:kbinfo KB834439 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.