none
Operational Database & Data Warehouse Database in the same SQL Server Instance

Answers

  • Hi,


    Regarding the multisite cluster:


    Only Cluster service quorum node clusters are supported. Multisite clusters (geographically dispersed clusters) are supported for all Operations Manager cluster roles. You can use replication technology to help provide high availability for data in Operations Manager, but the latency of communications between components introduce risks to data replication and might introduce failover issues. We recommend that you use synchronous mirroring of data disks between sites. Synchronous mirroring means that the data is fully synchronized across all sites and ensures the correct behavior of applications in the event of failover across sites.



    Regarding the Operations database and Data Warehouse on same instance (it is supported but not recommended) Check in Bold below


    Supported, But Not Recommended Cluster Configurations

    Operations Manager supports the following clustering configurations for Operations Manager server roles, as shown in the following table; however, because of a potential performance effect on your computer running SQL Server, these configurations are not recommended:

    Server Feature Cluster Notes

    Operations Manager operational database and Operations Manager Reporting data warehouse.

    Active-Active cluster where the operational database is installed on one node of the cluster and the Reporting data warehouse is installed on the other node of the cluster.

    There might be some performance issues with SQL Server in this configuration.

    Operations Manager operational database, Reporting data warehouse, and Audit Collection Services (ACS) database.

    Single Active-Passive or Active-Active cluster where all three components are on a single cluster.

    There might be some performance issues with SQL Server in this configuration.

    Operations Manager operational database and Audit Collection Services database.

    Single Active-Passive cluster where both components are on a single cluster.

    There might be some performance issues with SQL Server in this configuration.

    Operations Manager operational database and Reporting data warehouse.

    Single Active-Passive cluster where both components are on a single cluster.

    There might be some performance issues with SQL Server in this configuration.

    Reporting data warehouse and Audit Collection Services database.

    Single Active-Passive cluster where both components are on a single cluster.

    There might be some performance issues with SQL Server in this configuration.


    Regards,

    Mazen Ahmed


    Wednesday, April 25, 2012 9:53 AM

All replies

  • A single server scenario is supported too, just not recommended for production :).

    But yes it is supported, make sure you have enough resources though.


    Rob Korving
    http://jama00.wordpress.com/

    Tuesday, April 24, 2012 10:17 PM
  • In this link:

    Operations Manager Operational database
     Single Active-Passive cluster
     Other Operations Manager features must not be installed on the cluster or nodes of the cluster.

    What does it mean? Does It mean that I can't put in this Cluster SQL Instance the DW Database ????

    Wednesday, April 25, 2012 4:37 AM
  • Also, this cluster is multisite cluster with "Node and File Share Majority" configuration. I want to allocate only Operation & DW databases.

    In that link: Only Cluster service quorum node clusters are supported.

    I don't understand very well this article, it seems confuse....

     

    Wednesday, April 25, 2012 5:22 AM
  • Hi,


    Regarding the multisite cluster:


    Only Cluster service quorum node clusters are supported. Multisite clusters (geographically dispersed clusters) are supported for all Operations Manager cluster roles. You can use replication technology to help provide high availability for data in Operations Manager, but the latency of communications between components introduce risks to data replication and might introduce failover issues. We recommend that you use synchronous mirroring of data disks between sites. Synchronous mirroring means that the data is fully synchronized across all sites and ensures the correct behavior of applications in the event of failover across sites.



    Regarding the Operations database and Data Warehouse on same instance (it is supported but not recommended) Check in Bold below


    Supported, But Not Recommended Cluster Configurations

    Operations Manager supports the following clustering configurations for Operations Manager server roles, as shown in the following table; however, because of a potential performance effect on your computer running SQL Server, these configurations are not recommended:

    Server Feature Cluster Notes

    Operations Manager operational database and Operations Manager Reporting data warehouse.

    Active-Active cluster where the operational database is installed on one node of the cluster and the Reporting data warehouse is installed on the other node of the cluster.

    There might be some performance issues with SQL Server in this configuration.

    Operations Manager operational database, Reporting data warehouse, and Audit Collection Services (ACS) database.

    Single Active-Passive or Active-Active cluster where all three components are on a single cluster.

    There might be some performance issues with SQL Server in this configuration.

    Operations Manager operational database and Audit Collection Services database.

    Single Active-Passive cluster where both components are on a single cluster.

    There might be some performance issues with SQL Server in this configuration.

    Operations Manager operational database and Reporting data warehouse.

    Single Active-Passive cluster where both components are on a single cluster.

    There might be some performance issues with SQL Server in this configuration.

    Reporting data warehouse and Audit Collection Services database.

    Single Active-Passive cluster where both components are on a single cluster.

    There might be some performance issues with SQL Server in this configuration.


    Regards,

    Mazen Ahmed


    Wednesday, April 25, 2012 9:53 AM
  • Thanks Mazen, but...

    What does Only Cluster service quorum node clusters are supported mean" in my scenario. My SQL Geo Cluster (where i want to allocate operational and DW databases) has "Node and File Share Majority" quorum mode ??

    Wednesday, April 25, 2012 10:42 AM