第二章 部署与合并多个数据库实例
I. Deploying multiple instances
1. 设计数据库实例。当满足下列情况时，应安装多个数据库实例。
多个互相独立的sysadmin组
数据库服务器需要为不同的组织提供数据库
对不同的数据库实施不同的升级或者更新途径
隔离相同的SQL Server登录名
合并多个数据库服务器到单个数据库服务器
2. 规划数据库实例。下列是在建立多个数据库实例时的指南。
减少实例数量
设立命名习惯
为每个实例分配TCP端口
分配不同的服务帐户以增强安全性
确定内存分配
确定系统数据库的物理位置
尽可能使用多个物理服务器【集群】
性能
II. Planning database consolidation
1. Consolidating database server
(1) Database server consolidation is the process of reducing the number of database servers in an organization by migrating their hosted database to a central server.
(2) Benefits of database server consolidation
Software license
Monitoring
Optimizing hardware resources fully
Simplification of database server administration
Improved security: standardize strong security practices, update the software on the server more efficiently, and reducing the complexity of security management trends to improve security in an indirect way.
(3) Cost of consolidating database servers
Single point of failure
Reduction in server performance
Disk
Memory
CPU
Network
2. Designing a server consolidation plan
(1) Gather information about dispersed data
(2) Identify potential consolidation problems
(3) Create a migration plan
(4) Create a plan for testing applications
3. Consolidation plan guidelines
(1) Determine the number of databases, instances, and servers
(2) Include a rollback mechanism
(3) Test the consolidation procedure
(4) Define performance targets
(5) Review regulatory requirements
(6) Get approval from management
