To enable SQL Server to utilize all available memory more than 3GB you need to make sure that the following options comply,
1. /AWE is enable in boot.ini file
2. /PAE is enable in boot.ini file
3. AWE is enabled in SQL Server, and make sure from the server logs that it is enabled while server starts....
4. Enabled the Lock Pages in Memory
Also this is recommended to put max memory value to avoid OS to go under memory pressure, Suggested Max Memory Settings for SQL Server 2005/2008
Subscribe to:
Post Comments (Atom)
4 comments:
Brim over I assent to but I dream the brief should secure more info then it has.
[url=http://www.ganar-dinero-ya.com][img]http://www.ganar-dinero-ya.com/ganardinero.jpg[/img][/url]
[b]Estas buscando formas de ganar dinero[/b]
Nosotros hemos hallado la mejor guia en internet de como ganar dinero internet. Como nos ha sido de utilidad a nosotros, tambien les puede ser de utilidad a ustedes. No son solo formas de ganar dinero con su pagina web, hay todo tipo de formas para ganar dinero en internet...
[b][url=http://www.ganar-dinero-ya.com][img]http://www.ganar-dinero-ya.com/dinero.jpg[/img][/url]Te recomendamos entrar a [url=http://www.ganar-dinero-ya.com/]Ganar dinero desde casa[/url][url=http://www.ganar-dinero-ya.com][img]http://www.ganar-dinero-ya.com/dinero.jpg[/img][/url][/b]
Good brief and this mail helped me alot in my college assignement. Gratefulness you seeking your information.
Nice dispatch and this enter helped me alot in my college assignement. Thanks you seeking your information.
Post a Comment