large quantitiy of VPX_HISTS_STATx_xxx - Tables in SQL-DB

[chakoe]

Hi,

I´m using vCenter 5.1 Build 880146 with SQL-DB on an SQL2008 Std.Edition 64 Bit SP3.

We recognize, that our DB ( Filesize nearly 80 GB ) is growing very fast ( ~ 2 GB inside the DB per night ).

Log rentention in vcenter is set to 60 Days. And there is a large quantity of VPX_HISTS_STATx_xxx - Tables in SQL-DB ( 541 Tables )

Is this normal? We have a very big infrasturcture, but this was not recognized before we updated to 5.1..

Any ideas?

Thx in advance

Chakoe

[aravinds3107]

Check the below KB's if not done

Troubleshooting VPX_HIST_STAT table sizes in VMware vCenter Server 5.1

Reducing the size of the vCenter Server database when the rollup scripts take a long time to run

[SantoshKumar36]

Even I had the same issues. Please have a look in the below thread.

http://communities.vmware.com/message/2188991#2188991

Later on, we have deleted(I mean purging) the HISTS table in vCenter DB, then we could manage to bring the vCenter DB size to 8 GB.