3 Replies Latest reply on Mar 1, 2007 2:08 AM by acr

    Virtual Center : database Size

    mldmld Hot Shot

      Hi,

      For VC, what are the rules or best practises to size the oracle database ?

       

      May VC be in a VM ?

      What are the consequencies if the host of the VM running VC is KO.

       

      Thanks

      ML

        • 1. Re: Virtual Center : database Size
          acr Virtuoso

          Look at this.. Page 6.

           

          http://www.vmware.com/pdf/vc_technical_best.pdf

           

          Size of the database will vary depending on the number of

          hosts & VMs managed, frequency of performance data

          collection and type of database.

          Each stat sample collected is about 60 bytes for SQL, 100 bytes for Oracle, and

          each event stored is 1600 bytes for SQL, 600 bytes for Oracle.

          Using default settings, the statistical data for 25 hosts running 8-16 VMs per host

          will plateau around 40-60 MB in a year (80-140 MB if set to "full"). Each month, the

          average number of events generated will also consume about 190 MB in SQL, and

          70 MB in Oracle. Total DB size after a year is expected to be around 2.20 Gb in

          SQL, and 1.0 Gb in Oracle.

          Using default settings, the statistical data for 75 hosts running 8-16 VMs per host

          will plateau around 90-150 MB in a year (200-330 MB if set to "full"). Each month,

          the average number of events generated will also consume about 190 MB in SQL,

          and 70 MB in Oracle. Total DB size after a year is expected to be around 2.40 Gb in

          SQL, and 1.2 Gb in Oracle.

           

          Running the VC as a VM is a good idea, make use of HA and DRS, so it should always have enough resources to run and always be available..

           

          A lot of people do it.. Works well..

          • 2. Re: Virtual Center : database Size
            mldmld Hot Shot

            Thanks a lot, this is exactly what I was looking for !

            Best regards

             

            ML

            • 3. Re: Virtual Center : database Size
              acr Virtuoso

              thx, your welcome..