Federated MDBs with Multiple SQL Instances联邦数据库系统，具有多个SQL实例.pptVIP

Federated MDBs with Multiple SQL Instances Last Revision Date: September 6, 2006 Glossary The following terms and abbreviations are used in this presentation: “HA” = Highly Available “UAPM” – Unicenter Asset Management Portfolio “USD” = Unicenter Service Desk “DSM” – Unicenter Desktop Server Management “eIAM” = CA eTrust Embedded Identity and Access Management “MSCS” = Microsoft Cluster Server “NSM” = Unicenter Network System Management Overview Objectives The objective of this document is not to discuss MDB Federation or what products should share MDB. For a detailed discussion of MDB federation and deployment choices consult the MDB Federation presentation instead The main objective of this presentation is to review the implications of installing multiple SQL MDBs on a single server having multiple SQL instances. Additional information is provided regarding the install of multiple SQL MDBs in a Microsoft cluster environment These discussions assume that you have already reviewed the MDB Federation presentation and wish to pursue federation on the same server or same cluster Why use multiple SQL instances? Reduce cost of ownership If correctly planned, the normal mode of operation in a Microsoft Cluster environment can include active SQL instances on different nodes of the cluster. This provides federation without overloading single cluster node. In the event of a failover both SQL instances can potentially be active on the same node. This would not be classified as “normal” mode of operation Default SQL Instance Some products do not support named SQL instances. DSM is one of these, but it is targeted to support named instances soon. Although DSM will install correctly using named SQL instances, there are some issues with named SQL instances Therefore, if DSM is being installed in an environment using multiple SQL instances, one of the SQL instances should be the default instance. Multiple MDBs – one Product Installing multiple MDBs for the same product on the s