VMware Communities: Message List - How to change VC database insert rate

Re: How to change VC database insert rate

facuman — Wed, 01 Oct 2008 17:00:54 GMT

Hi Stefan, thanks for your answer. My VirtualCenter have the same parameters as your screenshot. I've been doing some tests and changing the "interval duration" only affects the number of samples that are inserted in the database not when they are inserted. For example:

With "Interval duration" = 5 -> 1 sample inserted every 5 minutes

With "Interval duration" = 1 -> 5 samples (one for each minute that has passed chronologically) inserted every 5 minutes

I want the insertion to happen each minute (not the 5 in one go).

Regards

Re: How to change VC database insert rate

azn2kew — Wed, 01 Oct 2008 15:28:18 GMT

You can read more in depth about SQL database performance insertion attached here as well.

If you found this information useful, please consider awarding points for "Correct" or "Helpful". Thanks!!!

Regards,

Stefan Nguyen
iGeek Systems Inc.
VMware, Citrix, Microsoft Consultant

Re: How to change VC database insert rate

azn2kew — Wed, 01 Oct 2008 15:26:36 GMT

Yes, you can change it from VI client, go to Adminstration->VirtualCenter Management Server Configuration->Statistics->click on 5 Minutes and edit to your choice. Good luck and welcome to forum. See attached image for details.

If you found this information useful, please consider awarding points for "Correct" or "Helpful". Thanks!!!

Regards,

Stefan Nguyen
iGeek Systems Inc.
VMware, Citrix, Microsoft Consultant

How to change VC database insert rate

facuman — Wed, 01 Oct 2008 15:08:38 GMT

Hi

Is it possible to lower the refresh rate of the performance statistics database insertion of VirtualCenter? By default, VirtualCenter insert performance statistics into the database every 5 minutes, I would like to change that. Is there any way?

Thanks and regards