Setting Microsoft SQL Server database parameters
When you install Sterling B2B Integrator with the Microsoft SQL Server database, you must set certain Microsoft SQL Server parameters. Other Microsoft SQL Server parameter settings are recommended for the efficient performance of Sterling B2B Integrator.
When you install Sterling B2B Integrator with Microsoft SQL Server, you must set the Microsoft SQL Server parameters that are listed in Mandatory settings for Microsoft SQL Server.
After you install Sterling B2B Integrator with Microsoft SQL Server, you can improve the database performance by setting the recommended parameters that are listed in the performance documentation for the following items: