vCenter

 View Only

  • 1.  max size of sql database

    Posted Mar 09, 2011 04:08 AM

    Hi,

    I have VC 4.1.0 Build 345043 with defaul SQL server db.

    I want to know if the db has a max file size limit of 4G ?

    if so what is the alternative ??

    I have reduced the db retention policy to 30 days

    anything else I can do ensure the db is not full ??    



  • 2.  RE: max size of sql database

    Posted Mar 09, 2011 04:24 AM

    yes the max is 4GB for MsSQL Express edition. have a look at this thread one how to clean up. http://communities.vmware.com/message/951217  Anyway there is a calculator and if you're within 3-4 hosts it will hardly get full.



  • 3.  RE: max size of sql database

    Posted Mar 09, 2011 04:34 AM

    I have 5 hosts and the file gets full.

    the calculator in the other thread is for VC2.0

    can I not add another datafile to the db ?     



  • 4.  RE: max size of sql database

    Posted Mar 09, 2011 11:16 AM

    You can also purge some of the performance data from your vCenter DB described in this KB article here:  http://kb.vmware.com/kb/1025914

    /Rubeck