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
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.