VMware Communities > VMTN > VMware vCenter™ > VMware vCenter™ Server > Discussions

This Question is Answered

2 "helpful" answers available (6 pts)
2 Replies Last post: Jun 12, 2008 6:24 AM by Gabrie
Reply

Statistics about number of vmotions (manual / drs)

Jun 12, 2008 12:40 AM

Click to view Gabrie's profile Master Gabrie 881 posts since
Jun 6, 2005

Hi

I would like to get more info about manual and automatic (DRS) performed vmotions. How many since data x? How many per day? What VMs get vmotioned the most? etc etc. Where can I get this data from?

Gabrie

http://www.GabesVirtualWorld.com

Reply Re: Statistics about number of vmotions (manual / drs) Jun 12, 2008 1:06 AM
Click to view Dave.Mishchenko's profile Guru Dave.Mishchenko 8,863 posts since
Nov 15, 2005
Moderator
The events will be in the vpx_event table in the VC. The 2nd will give you a list of all events types (or specifically the events that your VC database have recorded). You may find some useful events related that don't have migrate as part of the event type name.

SELECT vpx_event.event_type, vpx_event.vm_name, vpx_event.create_time from vpx_event where event_type like '%migrate%'

SELECT distinct(vpx_event.event_type) from vpx_event order by event_type
Reply Re: Statistics about number of vmotions (manual / drs) Jun 12, 2008 6:24 AM
in response to: Dave.Mishchenko
Click to view Gabrie's profile Master Gabrie 881 posts since
Jun 6, 2005
Thank you very much !!!!

http://www.GabesVirtualWorld.com

Actions