sqlserver 2000on windows 2000 memory issues

• sahmad43

  SSC Eights!

  Points: 926

  More actions

  October 11, 2008 at 9:53 am

  #72139

  I need to know why the properties menu of sqlserver 2000 under windows 2003 is showing max memory as 4 MB where as the physical memory in the box is 32 GB but when I use sp_configure it shows max memory as 2147483647 mb?

  thanks

• Jo Pattyn

  SSC-Dedicated

  Points: 32352

  More actions

  October 12, 2008 at 12:10 pm

  #883916

  Are the awe parameters setup correctly? (windows)

  Have you set the memory for sql server to a fixed size (min & max)?

  Sql server also needs the rights to lock pages in memory.

  Have a look at http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx