I'm working on a website project which has also a back-end application. Both projects rely on one instance of sql server 2008 . If both application are running sql-server becomes a sever bottleneck. Unfortunately it is not possible for us to scale-up (it is not possible to add more horse power on computer that is running sql-server) and now we a looking for other ways to improve performance.
We are using windows 2008 with sql-server 2008 enterprise edition on multiple virtual box.