minimum memory advisement?

[platypus]

Just a quick question:

Windows Server 2003 Standard, SQL Server 2000, a 6GB Database. What would most people recommend the minimum memory? I know basically more is better, but budgets are usually an issue.

 

[platypus]

Indeed it's standard, which means ~1.8GB of the database can be loaded into ram plus database overheads iirc? Upgrading SQL server is never likely to be a possibility.

 

[platypus]

That simply isn't an option sadly, given the need for a 64 bit o/s, a new sql database (2000 doesn't support over 2gbs ram) .