dingding
Enthusiast
Enthusiast

how to clean up obsolete data in VCMS database

Jump to solution

will VCMS auto clean up obsolete data in database, i'm afraid the database will be full one day.

---- Idleness is not doing nothing. Idleness is being free to do anything.
0 Kudos
1 Solution

Accepted Solutions
Dave_Mishchenko
Immortal
Immortal

Most of the size will be due to the performance data that you capture. The frequency of the data capture is configured in the VC client - go to Administration\Virtualcenter Management Server Configuration. Then select the Statistics page. If you change Collection Intervals, you can reduce the size of storage space you need. For example, you made not need the past years worth of data (up to the last month may be fine) and you can then delete that collection interval. You should also note that when you create a collection interval, you can set the detail level which will impact the amount of data storage space required.

If you need to you can manually delete data from the database. There's a good write up on that and managing collection intervals here: http://www.vmware-land.com/Vmware_Tips.html#VC4

View solution in original post

0 Kudos
1 Reply
Dave_Mishchenko
Immortal
Immortal

Most of the size will be due to the performance data that you capture. The frequency of the data capture is configured in the VC client - go to Administration\Virtualcenter Management Server Configuration. Then select the Statistics page. If you change Collection Intervals, you can reduce the size of storage space you need. For example, you made not need the past years worth of data (up to the last month may be fine) and you can then delete that collection interval. You should also note that when you create a collection interval, you can set the detail level which will impact the amount of data storage space required.

If you need to you can manually delete data from the database. There's a good write up on that and managing collection intervals here: http://www.vmware-land.com/Vmware_Tips.html#VC4

0 Kudos