I am a new DBA working for a charity and I have project to consolidate the multiple databases scattered across the organization.
I have identified the main databases that are mission critical to the organisation. We have a virtualised infrastructure. We currently run SQL Server 2008R2.
- Fundraising Database (off the shelf package)
- Case Load Services Database (Developed in house)
- Finance Database (off the shelf package)
Now the question I have is (bearing in mind limited budget and resources) is whether I should put all 3 of these databases on 1 single instance on 1 single Windows Server 2008 VM. Or would it be better to have them on a single box with 3 named instances? Or possibly even 3 separate VM Servers with 1 databases each?
So even though each database is mission/business critical it is ok to have all of them on 1 single instance. So we would create a virtualised windows 2008 server called SQL01 for example. Install 1 instance of SQL 2008r2 and restore all 3 databases on that single instance? Or would it be better to create 3 names instances on that single server and have each database within its own named instance?