I need to improve performance because currently my website is too slow.
I'm currently running SQL Server 2008 Express on a dual-core server with 2 GB of memory. My app seems to be CPU-bound currently, but will adding more memory lower the CPU usage? Or should I get a 2x dual-core server? Will SQL Server 2008 Web improve efficiency?