For sights that are a very tight fit, I don't worry about it, though I do always use some type of thread locker on sights that use a set screw. On dovetail sights with a looser fit, I've had good luck with loctite keeping in place a sight that would otherwise drift.