Tag Archives: chargeback


VMTurbo Part 2 – Chargeback

I finally encountered a company that does actual charge back for a virtual machine based on CPU, RAM and OS. Luckily, VMTurbo was also running in the environment keeping me aware of all of my hosts constraints but I digress. I was challenged with finding out what a VM costs so that a price could be given back to the consumer whether it was the DBA team or the eCommerce team. I was aware that VMTurbo has all the information to do showback, or as others like to call it shameback, but why not use it for actual chargeback? I know that’s not what¬†they advertise as a feature but I was stubborn. ¬†There had to be a better way to to extrapolate the information I needed from the application that already knows my environment!

I admit the spreadsheet took a lot of upfront work and mind numbing calculations, if you need assistance let me know. I had to take into account all hardware costs (MDS port, FI, etc) as well as the software costs (OS, Antivirus, backup software). The charge wasn’t just for an empty VM but possibly a Windows 2012R2 server running SQL and requiring backups running on a UCS environment. Using a SQL query and my cost analysis spread sheet, I can now see how much it is costing to run a VM with actual utilization and how much it costs to provision up front with the requirements requested.

My rudimentary spreadsheet ended up looking like this:

Now that I had my spreadsheet of awesome, I needed to use it with VMTurbo. I first created 2 groups based on operating system so I could separate my Linux VMs from Windows. There is obviously a price difference between running those operating systems.

Now that I had my groups saved, I had to create a custom report. The newer feature of VMTurbo allows you to input text which in my case was a SQL query.

The query looks at my groups and grabs their statistics. (Full code here)

Now that I have my VM Summary for Cost Showback saved I can run it and download to see what my VMs have allocated and what they are actually using.

Now here comes the fun part. Saving this output from, VMTurbo, I now import the data into my cost analaysis spreadsheet with macro goodness. I can now get a good idea of what a VM is costing me monthly, by what is allocated or by what it is actually using with numbers, for this particular environment. Missions accomplished! Please note, storage was not taken into consideration at this time as it was not a requirement for charge-back

No, that over-provisioned VM you are want to deploy is not free