Home Forums SQL Server 2012 SQL 2012 - General Multiple environment DB's on one instance or one instance per environment on a physical server RE: Multiple environment DB's on one instance or one instance per environment on a physical server

  • Well, you need to review a lot of things and also business decisions needs to be kept in mind. Few Pointers:

    1. One bad database can cause issue with the entire instance impacting all other DBs as well, so each DB should be maintained very intelligently.

    2. Security policies should be strongly setup on single instance as there would be different set of users needing accesses to perform different activities on the databases.

    3. Easy to manage a Single Instance then multiple instances.

    4. The server configuration (sp_configure) should be configured keeping in mind all other DBs/applications pointing to this instance.

    5. TempDB should be configured to make sure it serves the requirement for all DBs on the single instance.

    6. Maintenance jobs should be created/scheduled keeping in mind the entire server configurations.

    There could be more other experts might suggest, but these things atleast should be kept in mind when deciding.