Brief Description: On VMware, you want to query for VMs swapping out.
Problem:
I posted a longer script for checking VMware tools and Host build versions when looking for VMs that are swapping out in the last hour. It's maybe a little clunky if you just need to know what machines are swapping right now.
Solution:
Smaller query is below just to get a list of VMs Swapping out right now.
select h.name, MAX(s.sample_time), avg(s.stat_value) from vpx_entity h
join vpxV_hist_stat_daily s on s.entity = ('vm-'+ CONVERT (Varchar, h.ID))
where s.stat_name = 'swapped' and s.stat_value > 1
group by h.name
order by h.name
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment