vCenter

 View Only
  • 1.  how large should vcenter DB grow?

    Posted Feb 20, 2012 02:41 PM

    I've got a vcenter 5 DB (ms sql 2005) that has been upgraded from vsphere 4.1 to 5 - there are only 4 hosts with currently @50 vms, but the DB has grown to 24GB

    Does that seem larger than what I should expect?

    I think that this DB also has the update manager info in it - in other words there are not two seperate dbs (this was a historical accident, that has just been propagated across upgrades) but even with that - 24GB seems large to me.

    What do you think?



  • 2.  RE: how large should vcenter DB grow?

    Posted Feb 20, 2012 02:48 PM

    you may think about running your recovery model in simple mode, as well as truncating the logs.

    See also

    http://kb.vmware.com/kb/1003990

    http://kb.vmware.com/kb/1025914

    http://www.vmware.com/files/pdf/vc_microsoft_sql_server.pdf



  • 3.  RE: how large should vcenter DB grow?

    Posted Feb 21, 2012 04:41 AM

    thank you - these are very helpful.



  • 4.  RE: how large should vcenter DB grow?

    Posted Feb 21, 2012 05:14 AM

    The size will also depend on how verbose you want your statistics to be, and how long you want to keep them. Under Administration->vCenter Server Settings->Statistics, it will tell you how size estimations based on the aforementioned criteria.



  • 5.  RE: how large should vcenter DB grow?

    Posted Feb 21, 2012 07:43 PM

    So I created a sql maint plan, did a full backup of the db, and then also tried shrink and index maintenance tasks - but still the DB is at 25+GB which is just huge, especially when compared to the sizing suggested in Administration....Vcenter Server ... Statistics

    I have yet to dive into the 2 tids that seem to be manually purging data, as I thought maybe the shrink would do that - but before I get deep into next stages, I am wondering just what could really account for the DB having grown this large?

    I wonder if it has to do with update manager using the same DB?

    I'd like to fix that - perhaps I will uninstall update manager and then re-install using a different db.  Does anyone know if removing update manager will also delete it's data from the DB? Or, am I being wrong-headed and update manager is not responsible for this DB being so large in the first place?

    Thnx!