SQL Server 2012 notes Sharing-41: Database Consolidation Recommendations

Principles of Database integration

If you have more than one SQL, and the current resource utilization for each SQL is generally low, we can consolidate these SQL.

=========================================================

Integration approach

1) Deploy with multiple instances of a single server. An instance is a resource use and permission control boundary, security boundary, if the permission requirements are relatively high, independence is relatively high, you can consider this way;

2) The database of multiple systems is placed in an instance of a server, which is simple to manage, which can be used if the security management boundary of the same business group is blurred;

3) Adopt the method of virtualization, but to make some necessary optimization measures, such as I/O access, can achieve maximum performance;

4) can also be used in conjunction with the above several means;

========================================================

Other precautions

1) Multiple instances need to be upgraded multiple times when upgrading SQL;

2) A server can install different versions of the SQL Server instance, there is no mandatory requirement to first install a high version or a lower version first;

3) The operating system above WINDOWS8 does not support the installation of database versions below SQL 2005.

This article from "Zeng Hung Xin Technical column" blog, declined to reprint!