VMware Cloud Community
M3nB4sH
Contributor
Contributor

Performance chart tables in the database

Hello guys,

what is the name of the tables that vcenter save performance chart data in the database for virtual machines in real-time

Message was edited by: Ahmed Mohammed

Reply
0 Kudos
2 Replies
M3nB4sH
Contributor
Contributor

Help me please..

Reply
0 Kudos
cyberpaul
Enthusiast
Enthusiast

Hi,

real-time stats are actually provided by the ESXi hosts, not vCenter. That's why you cannot find them in the database.

If you need to obtain real-time stats, you can use PowerShell or Perl SDK to query them. In my experience, using Perl is noticeably faster and eventually I re-wrote my old PS script to Perl.

Funnily enough, I just wrote a simple tutorial for this :slightly_smiling_face: All you need to do is to install vSphere Perl SDK on a linux machine and then create a script using this guide:

https://www.vmware-vcli.com/2018/04/tutorial-get-vm-performance-data.html

Regards, Pavel

Reply
0 Kudos