SQL Server 2000 Enterprise, how much memory can it address and how?

• markw

  Grasshopper

  Points: 11

  More actions

  October 5, 2007 at 5:27 am

  #178018

  Our database server has been upgraded to 64bit Win2003 Enterprise with 18Gb or Ram. Howerver we are not sure if SQL 2000 Enterprise can address this kind of memory. Does anyone know if it can? If it can what would have to be done to get it to do so if anything at all OR would we be better off with 32bit Enterprise Win2003?

  Any help is appreciated as we need to make some decisions soon.

  Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737204

  More actions

  October 5, 2007 at 9:22 am

  #739577

  It can address this memory.

  http://support.microsoft.com/kb/274750

  As much as you can spare. I'd go 14-16GB.