Filter
Top Products
The tempdb database that is used by Microsoft SQL Server must be created with the
same collation as the default collation of Microsoft SQL Server. The Microsoft SQL
Server uses the tempdb database for results that are too large to fit in memory.
If the collations of the tempdb database and the Sterling B2B Integrator database
differ, the database engine must convert from the Sterling B2B Integrator collation
to the tempdb collation, and then back again before it sends the results to the
Sterling B2B Integrator server. These conversions might lead to severe performance
issues.
The collation that is required for the Sterling B2B Integrator database is a collation
that most closely matches the character set used by Java. By using this collation,
you can avoid character data conversions before the data is stored in the database
tables. Use the mandatory parameter that is described in the following table when
you configure the collation setting:
Parameter Value
Database Collation SQL_Latin1_General_CP850_Bin
Additionally, you must perform these tasks:
v Allow Microsoft SQL Server to manage memory dynamically (default).
v Disable any antivirus software that is running on the Microsoft SQL Server
data, transaction log, and binary files directory.
Recommended instance-specific settings for Microsoft SQL
Server
The use of the Microsoft SQL Server database with Sterling B2B Integrator includes
some recommended instance-specific settings for the database.
Parameter Value
Max server memory (MB) 500 MB to x MB depending on the amount of physical
memory available on your database server. if the server is
running only this SQL Server instance; x can be up-to 80%
of the physical memory (RAM).
Min server memory (MB) 0
Recommended database-specific settings for Microsoft SQL
Server
The use of the Microsoft SQL Server database with Sterling B2B Integrator includes
some recommended database-specific settings.
Parameter Value Notes
®
IsAutoCreateStatistics True This parameter
can be set to
False if you
have a
maintenance
plan.
IsAutoUpdateStatistics True This parameter
can be set to
False if you
have a
maintenance
plan.
52 Sterling B2B Integrator: Performance Management