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 |