Thursday, August 18, 2016

VMware Host Performance and Configuration Reports

So you are a DBA and you are in a virtual environment - VMware in particular.  You are curious to know the health of the VMware hosts in terms of CPU and RAM, but you really don't know how to get the data you need and you're not certain if the information you are asking for is entirely accurate.  Well, chances are you have access to the VMware databases themselves - if that is the case, you can create these reports based on a blog post from Jonathan Kehayias: "Querying the VMware vCenter Database (VCDB) for Performance and Configuration Information".

I have created five reports that are based on Jonathan's queries and you can download the RDL for the SSRS reports below - enjoy!

Host Configuration
CPU Ready Values (Daily)
CPU Ready Values (Weekly)
Memory Ballooned (Daily)
Memory Ballooned (Weekly)

Hopefully you find these useful,
Allen (@SQLTrooper)