1 2 Previous Next 18 Replies Latest reply on Jul 17, 2009 9:13 AM by dickybird Go to original post
      • 15. Re: Virtual center 2.5 no performance data
        RaleighJon Lurker

        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...

        • 16. Re: Virtual center 2.5 no performance data
          Box293 Hot Shot

           

          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.

           

           

          • 17. Re: Virtual center 2.5 no performance data
            stratolynne Hot Shot

             

            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.

             

             

             

             

             

             

             

             

             

             

             

             

             

             

            • 18. Re: Virtual center 2.5 no performance data
              dickybird Hot Shot

               

              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

               

               

              1 2 Previous Next