I've got 5 databases that run on separate servers using SQL Express. Some of these include a Citrix Datastore, Citrix Edgesite Server, an AV db, Time and Billing App, and a document management program. These all currently run on separate servers using SQL Express as mentioned.
I'm considering consolidating to one central SQL database to provide larger DB sizes and other benefits to the full SQL 2008 R2 platform. To save money I want to use a server with one quad core CPU using a per socket SQL license. The server I have is stocked with SATA drives.
How exactly should I partition/RAID everything to provide the best performance? Should all the DBs be on a single RAID set or all separated? Most configs I see seem to show recommendations for partitioning a server running only a single database.
Any guidance would be greatly appreciated.