@Dashrender said in SQL Server Express Edition Ram upgrade - suggestion.:

Where does the above mentioned caching come in?

The two biggest places are disk caches and application caches. For example, does all of SQL Server get moved into memory or only part of it? Does all of the database get moved into memory, or only part of it? (That last part is the part that gets capped at 1GB.) Do all of the OS components get loaded into memory, or loaded from disk as needed? Do the log files stay in memory?

@bhautik.shah said in IBM Server X3650 (Type7979I2S) Raid Problem? Server RAID Card 8K-L:

Now i have to decide add on raid controller on to this server.

A quality RAID controller is not cheap. Even the most entry level one will be worth more than a ten year old server. I would replace the server with one that comes with a RAID controller already.

If you are in the US, xByte makes this super affordable for Dell and now HPE servers. Outside of the US, I normally advice SuperMicro.