A 2012 Canadian study concluded that resveratrol may improve exercise capacity and especially it may benefits people with restricted exercise capacity, like heart failure patients.
Contrary to many of the internet reports, red wine can not replace exercise
To be effective, the compound would need to be used like a performance-enhancing supplement, with concentrations far beyond a glass of wine.