Article ID: 224818 - View products that this article applies to.
This article was previously published under Q224818
If you run both SQL Server 7.0 and Exchange Server 5.5 Service Pack 2 on a computer running BackOffice Server 4.5 or BackOffice Small Business Server 4.5, you must explicitly configure the memory used by SQL Server in order to address a known memory issue that occurs when the products co-exist on the same computer.
The minimum dynamic memory setting for SQL Server 7.0 must be increased from the default of zero to a value of at least 32 megabytes (MB).
It may be necessary to set the minimum memory for SQL Server higher than 32 MB to support SQL Server's processing load, as this setting will determine the memory used by SQL when Exchange Server is running and under load. In this environment, the maximum dynamic memory setting for SQL Server will not be reached. SQL Server and Exchange Server administrators should determine the amount of memory to be allocated to SQL Server that will optimize the overall performance of both applications. The SQL Server administrator must then set the SQL Server minimum memory option to this value. If the SQL Server database is supporting a third-party application, you may need to consult the application's documentation or vendor to find out how much memory SQL Server will need to support the application processing load.
To increase the minimum dynamic memory setting for SQL Server 7.0, follow these steps:
This is by design. In SBS, this allocation has already been made.