It generally refers to something that ruins a happy/good situation -- like throwing a cold wet blanket on someone out on a summer day.