I’m a tenant, and I’ve been at my place a little over 14 years.
The first couple years I was there they raised the rent at lease renewal. Then they got a new office manager, who has (so far) kept the rent the same but has added a water surcharge that has gone up over time. I think they’re going to raise the rent on me fairly significantly (~10%) the next time the lease renews, which will sort of be a bitter pill to swallow, but had they raised the rent a little every year or two, I’d probably already be paying that amount or more, so I’ll probably get over it. Psychologically the big jump is worse than several smaller jumps.
A lot of the things that cause tenants to move will be out of your control (job change/loss, family growth/shrinkage, etc). One guy I know had tenants who needed to move (I forget the reason), but they asked if he had any other properties that were more suitable for them. In other words, they wanted to keep him as a landlord, just not at that property. So do right by your tenants.