Lafayette's panicked reaction to former Detective Andy's enraged accusations that he killed Miss Jeanette. Terry's kind, calm consoling towards Lafayette also count for this as well.
Eric: Mr. Unflappable Stoic, breaking down in tears and begging Godric not to commit suicide.
"A human with me at the end, and human tears! Even after two thousand years, I can still be surprised. In this, I see God." If it wasn't Eric breaking down and weeping blood, it was Godric's total calm acceptance and joy combined with Sookie weeping that'll bring a lump to your throat.
Sookie's tear-filled speech to her parents' graves as she tells them that she'd rather walk the earth as a vampire than ever lie between their graves.
Big John Dixon singing "Life Matters" at Terry's funeral. Arguably, all the related scenes in that episode could qualify as a tearjerker.
Jessica's reaction to finding out Tara's dead.
Hoyt's reaction to finding out his mother died? Heart wrenching. Seeing Jason trying to console the man who, because of how much he hurt him had himself glamoured to forget he even met him, and getting rebuffed as a complete stranger? Devastating.
Arlene's dying hallucination of Terry one last time. It almost makes it sad that she survives as she is just so happy to see him one last time.
Sookie staking Bill so that he wouldn't die a horrible death from Hep V.