Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am a new DBA working for a charity and I have project to consolidate the multiple databases scattered across the organisation.

I have identified the main databases that are mission critical to the organisation. We have a virtualised infrastructure. We currently run SQL Server 2008R2.

  1. Fundraising Database (off the shelf package)
  2. Case Load Services Database (Developed in house)
  3. 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?

Some advice on how others have structured their SQL boxes with similar sets of databases would be really beneficial.

Many thanks

Mark

share

migration rejected from stackoverflow.com Mar 23 at 17:49

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Shawn Melton, Jon Seigel, RolandoMySQLDBA, Mark Storey-Smith, ypercube Mar 23 at 17:49

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Tip of the iceberg - the question or comments reveal an underlying issue that would need extensive investigation by a consultant or database vendor support team: issues like this do not fit the SE Q&A model well. For more information see this meta post." – Shawn Melton, Jon Seigel, RolandoMySQLDBA, Mark Storey-Smith, ypercube
If this question can be reworded to fit the rules in the help center, please edit the question.

Browse other questions tagged or ask your own question.