Defragmenting Virtual Center 4.x (Update)

In SQL Server Management Studio:

Use
go
dbcc showcontig (VPX_HIST_STAT1)
dbcc showcontig (VPX_HIST_STAT2)
dbcc showcontig (VPX_HIST_STAT3)
dbcc showcontig (VPX_HIST_STAT4)
go

If fragmented run:
dbcc indexdefrag ('', 'VPX_HIST_STAT1', 'PK_VPX_HIST_STAT1')
dbcc indexdefrag ('', 'VPX_HIST_STAT2', 'PK_VPX_HIST_STAT2')
dbcc indexdefrag ('', 'VPX_HIST_STAT3', 'PK_VPX_HIST_STAT3')
dbcc indexdefrag ('', 'VPX_HIST_STAT4', 'PK_VPX_HIST_STAT4')
go

vsphere, TPS, high memory utilization on Nehalem processors

After upgrading from ESX 3.5 to vsphere all of VMs were throwing memory alerts. I found this article

Basically with MMU and large page sizes enabled, TPS doesnt work so well because of the larger page size. For now I disabled the alerts, but there is also the option of disabling large page sizes.