VMware

This Question is Possibly Answered

1 "correct" answer available (10 pts) 2 "helpful" answers available (6 pts)
1 2 Previous Next 18 Replies Last post: Jul 17, 2009 9:13 AM by dickybird   Go to original post

Re: Virtual center 2.5 no performance data

15. May 27, 2009 11:52 AM in response to: polysulfide
Click to view RaleighJon's profile Lurker 1 posts since
May 27, 2009
i am having the exact same issues, and i'm pretty sure it's looking at the wrong database, it keeps saying it can't find object VPX_SAMPLE_TIME1 when it's clearly there. where do i check what database it's pointing to and change it? i am by no definition a DBA...

Re: Virtual center 2.5 no performance data

16. Jun 8, 2009 10:02 PM in response to: HyperSprite
Click to view Box293's profile Hot Shot 149 posts since
Jul 7, 2006

HyperSprite,

Your solution fixed the problem. For some reason SQL agent stopped. Started and service and set it to restart the service on failure. Ran the agent jobs and data appeared.

Re: Virtual center 2.5 no performance data

17. Jul 15, 2009 6:56 AM in response to: Box293
Click to view stratolynne's profile Enthusiast 72 posts since
Jan 29, 2009

I'm having the same problem with Virtual Center 2.5 Build 147633 Copyright 2009

Put these scripts into SQL and executed them.

delete_stats_proc
load_stats_proc
purge_stats1_proc
purge_stats2_proc
purge_stats3_proc
stats_rollup1_proc
stats_rollup2_proc
stats_rollup3_proc

Which database should they be executed to? vmupmgrdb or vcdb?

Is there a specific order of execution?

Is there one script that executes all the appropriate procedures (like in the installation)?

Appreciating any assistance in getting this working.


Re: Virtual center 2.5 no performance data

18. Jul 17, 2009 9:13 AM in response to: stratolynne
Click to view dickybird's profile Hot Shot 98 posts since
Aug 18, 2005

It should be run on your VC Database. The name you have selected during installation. You can also verify the name of Database you are using by going to ODBC connection and looking for the Database name in config to be sure.

By looking at the names provided by you , the VCDB maybe your VC database while the other one sounds like VC update manager

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