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:
vSphere 4.X vCenter log location
