Express 1GB memory

[RBSTR]

Hi
I have a client with a MSDE2000 database.
They have agreed to upgrade to a newer edition of SQL.
The Express edition does seem to tick all the right boxes at this stage but my only concern is the 1GB memory limit.
Their current MSDE sqlservr.exe process is reported in Task Manager as using 1.3GB memory. I'm not sure this is a true picture of memory usage. A colleague has suggested that it may be prone to 'memory leakage' and indeed the server has not been rebooted for maybe a year.
Should it prove to be true (current memory usage > 1GB) what would happen if they were to use Express edition ... would it not work or would it only use a max of 1GB of memory?

 

[hmckillop]

As far as I know it will only acquire the 1GB of memory as and when required. It will stop at 1GB regardless of how much memory on the physical server.

http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

For a small DB 1GB is fine, but like all things SQL , you need to test (if possible performance test) your application to see if there are any thresholds for your current and projected user base.



"I'm living so far beyond my income that we may almost be said to be living apart