Dear Gurus,



I am trying to decide whether I should pull the trigger on the 3GB
switch on an ecommerce SQL Server that I just inherited.



Select @@version =

'Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
Edition on Windows NT 5.2 (Build 3790: Service Pack 1)'



4GB Memory

Win 2K3 Enterprise Edition



Also, if I do the 3GB switch, do I also need to turn off Dynamic Memory
manager on the SQL Server?



Thanks for any advice. I've been monitoring the discussions and have
learned a lot. You guys are awesome!



Sincerely,



Gerald Hopkins




MS Sql Server LazyDBA home page