tubes tied

for those mamas who got their tubes tied, how was the process? how sore were you afterwards? did you gain weight afterwards? go through menopause? end up pregnant again? I've been trying to do a lot of research & the cons makes me nervous but I'm 110% done with having babies. as this is #5