VMware Cloud Community
ShekharRana
Enthusiast
Enthusiast

Performance History data not available

We have moved the sql database on new sql server since then VC not showing any performancy history data however realtime data is available.

Please help me to fix this issue, thanks in advance.

Reply
0 Kudos
2 Replies
SureshKumarMuth
Commander
Commander

Could you please give more details about the task you performed

Did you move complete vCenter database to new SQL server ?

Are you getting any error in the performance graph?

Check the size of hist tables and ensure they are not empty

Follow the steps given in the following article to check the size of hist_stat tables

VMware KB: Troubleshooting VPX_HIST_STAT table sizes in VMware vCenter Server 5.x

Regards,

Suresh

Regards,
Suresh
https://vconnectit.wordpress.com/
Reply
0 Kudos
ShekharRana
Enthusiast
Enthusiast

Yes, We moved complete databse on to new sql server.

We recreated the roll up jobs also after the DB migration.

Data is not available in performance graph, jobs are not empty.

Reply
0 Kudos