SQL Server Migrations
Right now we have a number of instances of SQL Express (mainly 2008) running on various servers and I was wondering if we would see any benifits from consolidating all those instances onto a single server?
Currently SQL runs our SharePoint server, Libary system, SCVMM and WSUS (maybe a few other little things).
If there would be an advantage the SQL Server would be hosted on our Virtual Server with whatever RAM/Processor allocation required (that shouldn't be tooo much of a problem unless I need to go over 2-4GB RAM).
i my self was thinking consolidating my sql servers into one but from the advise i got it wasn't recommend because the way sql is with regards to memory hungry i went to a conf a few weeks back where Microsoft was virtualizing sql servers and it seemed all ok but you need to think of the risk with everything being on one box i think your going to at least need a min of 8 to 16 gig of memory i might be wrong but then again i don't know what sort of setup you have and how big you are
you would have to create a new SharePoint/WSS farm as you can't move the sharepoint database from express to full SQL.