第二章 部署與合并多個(gè)數(shù)據(jù)庫實(shí)例
I.??? Deploying multiple instances
1.?設(shè)計(jì)數(shù)據(jù)庫實(shí)例。當(dāng)滿足下列情況時(shí)，應(yīng)安裝多個(gè)數(shù)據(jù)庫實(shí)例。
??多個(gè)互相獨(dú)立的sysadmin組
??數(shù)據(jù)庫服務(wù)器需要為不同的組織提供數(shù)據(jù)庫
??對不同的數(shù)據(jù)庫實(shí)施不同的升級或者更新途徑
??隔離相同的SQL Server登錄名
??合并多個(gè)數(shù)據(jù)庫服務(wù)器到單個(gè)數(shù)據(jù)庫服務(wù)器
2.?規(guī)劃數(shù)據(jù)庫實(shí)例。下列是在建立多個(gè)數(shù)據(jù)庫實(shí)例時(shí)的指南。
??減少實(shí)例數(shù)量
??設(shè)立命名習(xí)慣
??為每個(gè)實(shí)例分配TCP端口
??分配不同的服務(wù)帳戶以增強(qiáng)安全性
??確定內(nèi)存分配
??確定系統(tǒng)數(shù)據(jù)庫的物理位置
??盡可能使用多個(gè)物理服務(wù)器【集群】
??性能

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 布署與合并多個(gè)數(shù)據(jù)庫實(shí)例