Skip to Content
avatar image
Former Member

Multiple components on one Database Server

Hi, we have a customer, that question if we can group all database instances of products ERP EHP7, NW 7.31 (Portal), NW7.31 (BI_Content), NW 7.31 (AS Java with Nakisa), NW 7.4 (Process orquestration), Solution Manager 7.1, her installation is on Windows with database MSSQL Server, someone have some document with recommendations/restrictions about this? His objective is to reduce the number of VMs (Virtual Machines). We found one document about MCOD, but i want other forms to do this, installing various sap components using just one Database Server.

Best Regards,

Josue Neto

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 14, 2014 at 06:36 AM

    Hello,

    I would not suggest you to build MCOD system for all the solutions as it will impact other systems in case there is maintenance for one of the system.

    However, You can use Named instance approach for MSSQL in which you will install different database on same system but they will operate independently. Please refer to below link for more information.

    Multiple Instances in SQL Server (SAP Library - Database Administration in CCMS)

    Thanks,

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 14, 2014 at 06:03 PM

    Hi Josue

    Yes it is possible to keep the central common DB instance and share the entire SAP products application instance on other server

    In this environment you can have the central common DB for all SAP products of development and Quality SAP systems (Not on production). All the SAP products Dev & Qas usage are very less comparing production.

    In my environment we have common MS SQL 2008 R2 single DB for all the Dev & Qas system. the single DB server installed on Windows MSCS environment (Failover Cluster Single DB instance) so that we don't have any downtime of DB instance.

    Regards

    Sriram

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 25, 2014 at 12:48 PM

    Hi Josue,

    From the technical point of view you can either:

    • install several DB instances on one machine and use 1 DB within each instance
    • install only one DB instance on one machine and create several DBs within this single DB instance (one per system)
    • install each DB instance on one machine
    • install several systems into one DB within one instance (MCOD)

    Technically, all the above solutions are feasible and valid - the main question in this case is rather the question of performance and availability, therefore you need to find the perfect layout depending

    on your needs. Therefore, please consider a few details:

    1. Several databases within one instance:
      If you ever encounter a certain problem in one SAP system and you therefore need to bounce the SQL instance, you will automatically need a downtime for all systems that have their DB in the same instance.

    2. Several instances on one machine:
      If you run several DB instances on one machine and you need to reboot the server for a certain reason, you will automatically cause a downtime for all sap systems that are using one of the db instances on the machine.

    3. One machine per DB instance:
      In this case, your systems are the most independent from each other. If you need to restart the db instance for one system, it will affect this single system only. If you need to restart the OS it will still affect this single system only

    4. Several systems within a single database (MCOD)
      If you ever have a problem with this DB and need to restore it, take it offline or anything similar, it will affect all systems which store their data in this database.

    Additionally, you need to keep the resources in mind: if more than one DB instance is running on a server, you need to consider that the resource provided by this server (e.g. main memory, CPU) will need to be split up between all db instances, therefore, a single instance will not be able to use all resource but only a part of it.

    If you run more than one DB in one DB instance, the DB instance ideally should be assigned more resources (e.g. CPU and main memory) as it has to server more than one database.

    I hope these explanations help you to decide for the architecture and degree of distribution that fits your requirements best.

    Regards,

    Beate

    PS: In my opinion MCOD is not an option that you want to recommend these days.

    Add comment
    10|10000 characters needed characters exceeded