vCenter

 View Only
  • 1.  performance data missing in VC

    Posted Aug 14, 2012 12:05 PM

    Hello

    Recently i have face some issue in database, due to that  my performance data is missing now, I can see all old events but not with performance data, when i look into the VPX_HIST_STAT1, VPX_HIST_STAT2, VPX_HIST_STAT3, VPX_HIST_STAT4, there are morethan 40000 records on each table, now i want to get the report in VC, anyone is have any idea appericated, I am really weak in SQL

    VC version 4.0



  • 2.  RE: performance data missing in VC

    Posted Aug 14, 2012 12:13 PM


  • 3.  RE: performance data missing in VC

    Posted Aug 14, 2012 01:06 PM

    some article says that purging old data will solve the issue, but i am afraid, will this definate solve the issue, i am getting following error in vpxa

    [2012-08-13 17:34:16.464 06320 warning 'App'] [VdbStatement] SQL execution took too long: purge_stat1_proc
    [2012-08-13 17:34:16.464 06320 warning 'App'] [VdbStatement] Execution elapsed time: 119484 ms

    [2012-08-13 17:35:14.839 04720 error 'App'] [VdbStatement] Diagnostic data from driver is 23000:5:2601:[Microsoft][SQL Native Client][SQL Server]Cannot insert duplicate key row in object 'dbo.VPX_HIST_STAT1' with unique index 'PK_VPX_HIST_STAT1'.



  • 4.  RE: performance data missing in VC

    Posted Aug 14, 2012 01:39 PM


  • 5.  RE: performance data missing in VC

    Posted Aug 14, 2012 02:20 PM

    rebuilding index may solve it, but i have to try, will let you know th result, mean time if anyone has fixed this same type of issue please welcome their comment