VMware Cloud Community
kobzooms1
Contributor
Contributor

Database Log full

I use VM-Ware vSphere 5.5, vCenter 5.5 and MS.SQL 2008
Express.

The problem is the Database Log is full and I already solve
this problem as following;

Purging old data from the database used by vCenter Server

https://kb.vmware.com/s/article/1025914 but
is still cannot solve it so I have a question as below.

1. After the Purge has been restored, we get available space
at 10-15 MB. Is there another method to get more space?

2. From the table of the database as attached picture, which
column, row or data that I can delete in order to get more space? please kindly
advice.

vmtable_1.png

vmtable_2.png

Tags (1)
Reply
0 Kudos
2 Replies
vijayku
VMware Employee
VMware Employee

You can get rid of VPX_EVENT which contains the VIEvents details, also VPX_HIST_STAT4 contains the performance data, which can be cleaned up as per VMware Knowledge Base​, if not required.

Reply
0 Kudos
IRIX201110141
Champion
Champion

Event and stat4 table are "penuts".

Take a look to VMware Knowledge Base how to decrease the size of the VPX_TEXT_ARRAY table.

Regards,

Joerg

Reply
0 Kudos