sqlserver sp_configure 'max server memory' | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sqlserver sp_configure ‘max server memory’

Hi, I have SQL Server 2000 Enterprise installed on a system with Windows 2003 Server Enterprise and 8 GB of Ram. I want to have sqlserver utilize more than 2 GB of Ram. I’m unable to set ‘max server memory’ to a figure larger 2147483647. Any ideas as to why this may be?
Check: http://www.sql-server-performance.com/awe_memory.asp Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
Also checkhttp://www.sql-server-performance.com/sql_server_performance_audit5.asp this link on AWE enabled topic. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>