This is a question that many health conscious drinkers have been pondering and a number of studies have been carried out on the subject.
Ultimately it appears that moderate red wine consumption (ie. one glass a day) can have numerous health benefits, mainly due to its high content of powerful antioxidants but excessive consumption can have the adverse effect.
Source: http://www.alternet.org/personal-health/red-wine-it-healthy-you