My Oracle Support Banner

How to Improve the Performance of ATG Applications Using Microsoft SQL Server (Doc ID 1037890.1)

Last updated on NOVEMBER 04, 2019

Applies to:

ATG Outreach - Version 2006.3 and later
Oracle Commerce Merchandising - Version 2006.3 and later
Oracle Commerce Platform - Version 2006.3 and later
Oracle ATG Web Commerce Search - Version 2006.3 and later
Oracle Commerce Service Center - Version 2006.3 and later
Information in this document applies to any platform.
This applies to the Commerce and Content Administration (CA) platform using Microsoft SQL Server (MS-SQL).



Goal

To improve the performance of ATG applications using Microsoft SQL Server when the BCC, the customer facing site, or CA deployments are slow or hanging with database blocking sessions or deadlocks.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Verify Supported Environments
 Disable Unicode
 MS SQL Server 2005 and later JDBC driver
 Additionally, for MS SQL Server 2005 JDBC driver version 1.2 and later:
 MS SQL Server 2005 and later
 i-Net JDBC drivers (any version)
 MS SQL Server 2000
 loadItemBatchSize
 Troubleshooting MS SQL Server deadlocks
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.