DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 318818 - Last Review: February 27, 2014 - Revision: 2.0

This article was previously published under Q318818
This article has been archived. It is offered "as is" and will no longer be updated.

SYMPTOMS

When you use XA transactions with Microsoft SQL Server through the Merant JDBC driver, you may notice that performance slows.

CAUSE

This problem occurs because the Microsoft Distributed Transaction Server (MS DTC) xa_end call has thread affinity. This thread affinity forces a lot of thread management, which causes a big performance hit for the driver when you use XA transactions.

RESOLUTION

To resolve this problem, obtain Microsoft COM+ Hotfix Rollup 19. This hotfix replaces the thread affinity restriction of the xa_end call with a new switch to an xa_open string. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
318105  (http://support.microsoft.com/kb/318105/EN-US/ ) INFO: Availability of Windows 2000 Post-Service Pack 2 COM+ Hotfix Rollup Package 19
To resolve this problem, obtain the latest service pack for Windows 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
260910  (http://support.microsoft.com/kb/260910/EN-US/ ) How to Obtain the Latest Windows 2000 Service Pack

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Windows 2000 Service Pack 3.

MORE INFORMATION

For additional information about how to obtain a hotfix for Windows 2000 Datacenter Server, click the article number below to view the article in the Microsoft Knowledge Base:
265173  (http://support.microsoft.com/kb/265173/EN-US/ ) The Datacenter Program and Windows 2000 Datacenter Server Product
For additional information about how to install multiple hotfixes with only one reboot, click the article number below to view the article in the Microsoft Knowledge Base:
296861  (http://support.microsoft.com/kb/296861/EN-US/ ) Use QChain.exe to Install Multiple Hotfixes with One Reboot
The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

APPLIES TO
  • Microsoft COM+ 1.0, when used with:
    • Microsoft Windows 2000 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbfix kbwin2000presp3fix kbwin2000sp3fix KB318818
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support