when i changed this from 1 to 0 and moved a vm to this host, I am not seeing much different in the value of consumed Host memory and active guest memory.
are these supposed to drop if I enabled this setting?
Active Guest Memory is not the right value to look at. You need to check Shared in vCenter or SHRD in esxtop.