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. |
| Page_verify_option | Checksum (Microsoft SQL Server default) | |
| READ_COMMITTED_SNAPSHOT | On |