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:
Go to Start, Programs, Microsoft SQL Server 7.0, Service Manager. The SQL Server Service Manager dialog box will appear.
Make sure that MSSQLServer appears in the Services list. Click Start, and click Continue.
When SQL Server starts, go to Start, Programs, Microsoft SQL Server 7.0, and then click Enterprise Manager.
In the console tree, expand the Microsoft SQL Servers node, and then expand the SQL Server Group node.
Right-click the node of your SQL Server, and click Properties.
Select the Memory tab.
Under Dynamically Configure SQL Server Memory, drag the Minimum (MB) memory slider to the right until it says 32MB.
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.
Apple CEO Steve Jobs made the right move in skipping out on his company's last appearance at Macworld: In a Tuesday keynote address at the conference, Apple had no interesting new products to sell, opting instead to spend mind-numbing amounts of time on ...
Microsoft Learning Snack - Green IT Through Virtualization Many organizations face rising operating costs caused by excessive energy consumption. Virtualization and "Green IT" can help cut these costs. Get the information you need to bring Green IT savings to your business.
Order Your Fundamentals CD Today! Register today for your in-depth copy of one of three Fundamental CDs on the following topics – Exchange, SQL, and SharePoint.
Microsoft Learning Snack - Virtualization Basics With virtualization, computing components essentially become on-demand services, freeing each element of a system from the others. This short video explains the needs, benefits, and technologies behind virtualization.
Microsoft Learning Snack - Virtualization Basics With virtualization, computing components essentially become on-demand services, freeing each element of a system from the others. This short video explains the needs, benefits, and technologies behind virtualization.
Empower Your Processes with PowerShell 201 Paul Robichaux delves deep into PowerShell how-tos in 3 informative lessons, each followed by live Q&A—all on your own computer! Register today!
Microsoft Learning Snack - Green IT Through Virtualization Many organizations face rising operating costs caused by excessive energy consumption. Virtualization and "Green IT" can help cut these costs. Get the information you need to bring Green IT savings to your business.
New Release: Windows IT Pro Master CD 13 years of content archives, fast answers with advanced search tools, and full access to WindowsITPro.com—order today!
Register
