 | |
#131
 
| |||
| |||
|
Re: Boot.ini -
06-28-2008
, 08:13 AM
|
Why is it not a best practice when there is only one SQL instance? Linchi "Riccardone" wrote: Ok, I try to explain in other words: 'max server memory' is cleary an sql option On win2000 server Microsoft "strongly recommend" to set max server memory option always to optimize AWE enabled system. On win2003 server, setting the min and max server memory options are "only" a best pratice when there are more than one instance on a node or in case of a fail over occours. regards Riccardo di Nuzzo On 24 Giu, 18:05, Linchi Shea <LinchiS... (AT) discussions (DOT) microsoft.com wrote: 'max server memory' is a SQL Server configuration setting regardless of what OS the SQL instance may be running on. It's generally a good idea to cap the SQL Server buffer pool size (and set the min server memory) so that you avoid all this give-and-take of memory at the OS level. Linchi "Riccardone" wrote: cut and paste from one of million msdn articles about this recommended setting for "windows 2000" (and not sql server enterprise or other sql server version) http://msdn.microsoft.com/en-us/library/ms190731.aspx ---------------------------------------------------- For Windows 2000, unless a value has been specified for max server memory, SQL Server reserves almost all available memory during startup, leaving 128 megabytes (MB) or less physical memory for other applications. (When AWE is not enabled the amount of physical memory left for other applications can be controlled by max server memory.) For Windows Server 2003, the AWE mapped memory management is dynamic, so that only a small portion of the total available physical memory is allocated during startup. ---------------------------------------------------- Regards Riccardo di Nuzzo On 23 Giu, 07:12, "Uri Dimant" <u... (AT) iscar (DOT) co.il> wrote: No It applies to Microsoft SQL Server 2005 Enterprise Edition as well. See at the bottom of the article "Riccardone" <riccar... (AT) libero (DOT) it> wrote in message news:20250cb1-d5be-416e-a33c-09be39dcff65 (AT) x41g2000hsb (DOT) googlegroups.com... On 22 Giu, 07:22, "Uri Dimant" <u... (AT) iscar (DOT) co.il> wrote: In addition on Linchi's comment , do you consider to set MAX memory for SQL Server? this setting is recommended on a win2000 os only. Regards Riccardo- Nascondi testo citato - Mostra testo citato- Nascondi testo citato - Mostra testo citato |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.