When connecting to a Windows connection to a VM connection, what load is put on the VMware host?
Relatively not much, compared with windows and SQLServer connections.
Here's an explanation for what we collect and the frequency.
By default once every 5 minutes the diagnostic server gets a list of VMWare images.
If the spotlight client drills into the VMWare drilldown the query to get the list of VMWare images gets refreshed every 15 seconds.
If the VMWare connection is attached to the windows collection one query collects every 5 minutes ESX metrics for ‘Virtualization Overhead’, ‘Virtualized Memory’ and ‘Virtualized CPU’.
If spotlight client drills into the windows connection which has the VMWare connection attached this query gets executed every 15 seconds.