How to I improve performance running SQL Server 7.0 and Exchange 5.5 SP2?

A. If you run both SQL Server 7.0 and Exchange Server 5.5 Service Pack 2 (SP2) on a computer running BackOffice Server 4.5 or Small Business Server (SBS) 4.5, you must explicitly configure the memory that SQL Server uses. You must increase the minimum dynamic memory setting for SQL Server 7.0 from the default value of zero to a value of at least 32MB. (You might need to set it higher to support SQL Server's processing load because this setting determines the memory that SQL Server uses when Exchange Server is running and under load. In this environment, SQL Server won't reach the maximum dynamic memory setting.) SQL Server and Exchange Server administrators should determine the amount of memory to allocate 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 supports a third-party application, you might need to consult the application's documentation or vendor to find out how much memory SQL Server needs to support the application processing load.

To increase the minimum dynamic memory setting for SQL Server 7.0, perform the following steps:

  1. Go to Start, Programs, Microsoft SQL Server 7.0, Service Manager. The SQL Server Service Manager dialog box will appear.
  2. Make sure that MSSQLServer appears in the Services list. Click Start, and click Continue.
  3. When SQL Server starts, go to Start, Programs, 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, and 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 32MB.
  8. Click OK, and then close the SQL Server 7.0 Enterprise Manager.

For the new settings to take effect, you must stop and then restart the MSSQLServer service.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.