VMWare VCenter data

image

VMWare VCenter platform is a goldmine of useful data if you want to know whats going on with your virtual servers.

Statistical data is stored in an SQL Server database and you can either query views or the tables directly.
You get views for daily, weekly, monthly or yearly statics of your physical and virtual machines and you are able to query cpu, disk and a lot of other measurements.

VPXV_HIST_STAT_DAILY
VPXV_HIST_STAT_WEEKLY
VPXV_HIST_STAT_MONTHLY
VPXV_HIST_STAT_YEARLY

We have a couple of TV screens in our office so I created a Perl script that grabs real time data from this database and displays it.

You now get an overview on which server is doing what and how much CPU, DISK IO, Network traffic it generates without having to open up VCenter and connect to each and every host.

The solution is built using Perl with GD::Graph, a free module for creating graphs.

If you are a DBA or an administrator, I highly recommend having a look at the VCenter database. Some more information about the various tables can be found here:

http://ericsiebert.com/Vmware_Tips.html#VC6
http://vmprofessional.com/material/VcER_Diagram.pdf
http://www.vmware.com/pdf/vc_dbviews_2x.pdf

This entry was posted in DBA, Perl, VMWare. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *