Skip to Content
avatar image
Former Member

Shared MS SQL DB in VMware?

We are trying to put the following systems into one VMware server:

- Solution Manager (SMD)

- ECC 6.0 Development System (ECD)

- ECC 6.0 QA System (ECQ)

Ideally, we would like to partition our VMware server like this:

- Partition 1 - DB - Windows 2008 R2 Server + MS SQL - 2 CPU cores - 20 GB memory

- Partition 2 - APP - Windows 2008 R2 Server + SMD - 1 CPU core - 4 GB memory

- Partition 3 - APP - Windows 2008 R2 Server + ECD - 2 CPU cores - 4 GB memory

- Partition 4 - APP - Windows 2008 R2 Server + ECQ - 3 CPU cores - 4 GB memory

Basically, we want to share the database. The user count will initially be limited to 1, but might increase to 5 next year.

Hardware is Dual Xeon E5520 with 32GB RAM.

Is this setup possible? What is the typical way to set this up? What can be combined and what can't? Can we optimize it further? Maybe just one CPU core for the db?

I already looked through some of the existing documentation, but I couldn't find any good answers so far.

I also order the German book about virtualization from SAP.

Any feedback would be appreciated.

Thanks,

Jens

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 25, 2010 at 06:15 AM

    > Ideally, we would like to partition our VMware server like this:

    >

    > - Partition 1 - DB - Windows 2008 R2 Server + MS SQL - 2 CPU cores - 20 GB memory

    > - Partition 2 - APP - Windows 2008 R2 Server + SMD - 1 CPU core - 4 GB memory

    > - Partition 3 - APP - Windows 2008 R2 Server + ECD - 2 CPU cores - 4 GB memory

    > - Partition 4 - APP - Windows 2008 R2 Server + ECQ - 3 CPU cores - 4 GB memory

    Be aware that Windows 2008 R2 is not yet supported, the installation will mots likely fail with that OS version. See http://www.sdn.sap.com/irj/sdn/windows?rid=/webcontent/uuid/901004e6-15ce-2c10-afa4-ec948139a17c [original link is broken]

    > Basically, we want to share the database. The user count will initially be limited to 1, but might increase to 5 next year.

    So you mean you want to use MCOD?

    > Is this setup possible? What is the typical way to set this up? What can be combined and what can't? Can we optimize it further? Maybe just one CPU core for the db?

    I'd not install any server with less than 2 CPUs. Apart fromt that the setup looks good.

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Markus!

      These are great optimization suggestions.

      Yes, we were planning to use Windows 2008. My fault. We bought 2008 R2, but MS allows downgrading to 2008. I just forgot to update it in my documentation.

      I will post back when the system is up and running. Maybe others will be able to benefit from our experience.

      Best regards,

      Jens