Simple Memory Tuning of SQL Server 7.0

If both Microsoft® SQL Server™ 7.0 and Microsoft Exchange Server 5.5 are installed on a server, simple memory tuning is required for SQL Server 7.0 in order to address a known memory issue. You must increase the minimum dynamic memory setting for SQL Server 7.0 from the default of zero to the value of 32 megabytes due to the interaction between the memory models used by Exchange Server and SQL Server when installed on the same system. You can do this easily using the SQL Server Enterprise Manager.

To increase the minimum dynamic memory setting for SQL Server 7.0

  1. Click Start, point to Programs, point to Microsoft SQL Server 7.0, and then click Service Manager. The SQL Server Service Manager dialog box appears.
  2. Make sure that MSSQLServer appears in the Services list, and then click Start/Continue. If MSSQLServer does not appear, find it in the list box.
  3. After Microsoft SQL Server has started, click Start, point to Programs, point to Microsoft SQL Server 7.0, and then click Enterprise Manager.
  4. In the Console tree, expand the Microsoft SQL Servers node, and then expand the SQL Server Group node.
  5. Right-click the node of your SQL Server computer, and then click Properties.
  6. Select the Memory tab.
  7. Under Dynamically configure SQL Server Memory, drag the Minimum (MB) memory slider to the right until it says 32 MB.
  8. Click OK and then close the SQL Server 7.0 Enterprise Manager.
  9. Using Microsoft SQL Server 7.0 Service Manager, click Stop and wait for the MSSQLServer service to stop. Click Yes in the SQL Server Service Manager confirmation dialog box.
  10. If you wish to restart the MSSQLServer service, you can do so at this time by clicking Start/Continue.