第二章 部署與合并多個數據庫實例
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

?

443.Chapter2 布署與合并多個數據庫實例