Missing historical performance data in vCenter

After upgrade from vSphere 4.0 to vSphere 4.1 U1 a colleague of mine notice that there are a lot of gaps  in historical performance data.  Problems got started from the date which vCenter was upgraded to newest version.

Below part of the vpxd.log from vCenter with error message in vpxd.log – ” SQL execution took too long ”

[learn_more caption=”vCenter logs”] [2011-06-09 11:38:38.234 12452 warning ‘App’] [VdbStatement] SQL execution took too long: process_temptable2_proc [VpxLRO] — BEGIN task-internal-281 — — vmodl.query.PropertyCollector.createFilter — EB4C8471-B557-4ACE-A2E2-AA1550BCFC45(1DFCBA76-DF71-4B75-ACD6-4DCDABFB39A6) [2011-06-09 11:38:32.406 04980 info ‘App’ opID=545FD9BA-00000035] [VpxLRO] — FINISH task-internal-281 — — vmodl.query.PropertyCollector.createFilter — EB4C8471-B557-4ACE-A2E2-AA1550BCFC45(1DFCBA76-DF71-4B75-ACD6-4DCDABFB39A6) [2011-06-09 11:38:32.411 04980 info ‘App’ opID=545FD9BA-00000036] [VpxLRO] — BEGIN task-internal-282 — — vmodl.query.PropertyCollector.createFilter — EB4C8471-B557-4ACE-A2E2-AA1550BCFC45(1DFCBA76-DF71-4B75-ACD6-4DCDABFB39A6) [2011-06-09 11:38:32.412 04980 info ‘App’ opID=545FD9BA-00000036] [VpxLRO] — FINISH task-internal-282 — — vmodl.query.PropertyCollector.createFilter — EB4C8471-B557-4ACE-A2E2-AA1550BCFC45(1DFCBA76-DF71-4B75-ACD6-4DCDABFB39A6) [2011-06-09 11:38:32.429 12452 warning ‘App’] [VdbStatement] SQL execution took too long: process_temptable1_proc [2011-06-09 11:38:32.430 12452 warning ‘App’] [VdbStatement] Execution elapsed time: 82181 ms[/learn_more]

He has found on VMware communities that the others VMware customers had also similar problems after upgrade.
Link to KB article with scripts which solved our issue:

http://kb.vmware.com/1014209

vSphere 4.X vCenter log location

http://kb.vmware.com/1021804

Artur Krzywdzinski

Artur is Consulting Architect at Nutanix. He has been using, designing and deploying VMware based solutions since 2005 and Microsoft since 2012. He specialize in designing and implementing private and hybrid cloud solution based on VMware and Microsoft software stacks, datacenter migrations and transformation, disaster avoidance. Artur has been in IT industry since 1999 and consulting since 2008. Artur holds VMware Certified Design Expert certification (VCDX #077).