Resveratrol is a natural compound found in red wine that has been suggested to exert its potential health benefit through the activation of SIRT1, a crucial member of the mammalian NAD+-dependent deacetylases. SIRT1 has emerged as an attractive therapeutic target for many aging related diseases, however, how its activity can only be activated toward some specific substrates by resveratrol has been poorly understood. Herein, by employing extensive molecular dynamics simulations as well as fragment-centric topographical mapping of binding interfaces, we have clarified current controversies in the literature and elucidated that resveratrol plays an important activation role by stabilizing SIRT1/peptide interactions in a substrate-specific manner. This new mechanism highlights the importance of the N-terminal domain in substrate recognition, explains the activity restoration role of resveratrol toward some "loose-binding" substrates of SIRT1, and has significant implications for the rational design of new substrate-specific SIRT1 modulators.