VMware

This Question is Not Answered

1 "correct" answer available (10 pts) 1 "helpful" answer available (6 pts)
3 Replies Last post: Oct 1, 2008 10:00 AM by facuman  

How to change VC database insert rate posted: Oct 1, 2008 8:15 AM

Click to view facuman's profile Lurker
facuman
2 posts since
Oct 1, 2008
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

Tags: virtualcenter, database

Re: How to change VC database insert rate

1. Oct 1, 2008 8:26 AM in response to: facuman
Click to view azn2kew's profile Champion
azn2kew
2,941 posts since
Jun 21, 2006
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
Attachments:

Re: How to change VC database insert rate

2. Oct 1, 2008 8:28 AM in response to: azn2kew
Click to view azn2kew's profile Champion
azn2kew
2,941 posts since
Jun 21, 2006
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
Attachments:

Re: How to change VC database insert rate

3. Oct 1, 2008 10:00 AM in response to: azn2kew
Click to view facuman's profile Lurker
facuman
2 posts since
Oct 1, 2008

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

Actions

VMware Developer

SDKs, APIs, Videos, Learn and much more in the Developer community.

Learn More

Developer Sample Code

Increase your developer productivity with VMware API sample code.

Learn More

VMworld Sessions & Labs

Online access to the latest VMworld Sessions & Labs and online services.

Learn more

Purchase PSO Credits Online

Purchase credits to redeem training and consulting services online.

Buy Now

Community Hardware Software

View reported configurations or report your own.

Learn More

VMware vSphere

Come witness the next giant leap in virtualization.

Register Today

Communities