The ram is OKish for most games, even for today. But as everyone above said, the CPU is a killer here. Instead of having to upgrade your whole system, look for the higest AMD CPU your motherboard can support. I belive it will support the older X2 Dual Cores.
If you give me your MoB specs, I can check it out for you.