Microsoft KB Archive/272432

= BUG: SQL Server Books Online Server Memory Options Topic Refers to Wrong Memory Setting =

PSS ID Number: 272432

Article Last Modified on 10/17/2003

-

The information in this article applies to:


 * Microsoft SQL Server 7.0
 * Microsoft SQL Server 2000 (all editions)

-



This article was previously published under Q272432



Bug #: 58345

Bug #: 235552



SYMPTOMS
In the SQL Server Books Online topic, &quot;Server Memory Options,&quot; the passage subsection &quot;Setting the Memory Options Manually&quot; is misprinted. The following excerpt is taken from that topic:

There is a short delay between the start of a new application and the time SQL Server releases memory. Using max server memory prevents this delay and may give better performance to the other application. Only set min server memory if the start time of new applications sharing the same server as SQL Server shows up as a problem. It is better to let SQL Server use all of the available memory.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
The third sentence in the preceding excerpt should refer to &quot;max server memory&quot; instead of &quot;min server memory&quot;:

Only set max server memory if the start time of new applications sharing the same server as SQL Server shows up as a problem.

Additional query words: BOL

Keywords: kbBug kbpending KB272432

Technology: kbAudDeveloper kbSQLServ2000 kbSQLServ2000Search kbSQLServ700 kbSQLServSearch

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2004 Microsoft Corporation. All rights reserved.