I have found something that seems to have FINALLY solved it for me thanks to a two-year old reddit thread I stumbled upon. I almost literally looked over the internet like a 1000 times trying to find any solution and finally ran across this post:
https://www.reddit.com/r/ffxiv/comme...yd&sh=5bc76fc8
Long story short: this post mentioned something none of all the other troubleshooting guides did and I'm referring to this part:
Turning this 'Energy Efficient Ethernet' option to 'disabled' has made my connection to FFXIV stable, lag- and DC-less for three days straight now!Then Device manager > Network Adapters > Right click NIC...
... Advanced > Energy Efficient Ethernet. Make sure it's disabled.(Edit: to get ahead here, this is not the same as the option for the computer to turn the device off to save power.)
To give some background, I would have these minuscule DC's that would kick me back to the game's starting screen. I could just press Start and relog on my character instantly, but you can imagine this hampered gameplay a lot in some situations (losing all your TP for instance upon relog). The funny thing was that this DC *ahum* luckily happened a lot more often when I was in the Residential Zones and I had no idea why. I've made two previous threads about this problem throughout 3 years of playing, so you can probably imagine I'm feeling pretty relieved now.
I had tried all of the software things otherwise suggested. Flushing DNS, turning off the option for the computer to turn the network card off, Using google's open DNS, updating and clean installing my network card drivers. Hardware wise I swapped cables around, rebooting and updating my modem's firmware and such except for getting a new network card or modem, which would too expensive. I also only had the DC problem in FFXIV, so I tried port-forwarding which also didn't solve the issue (on top of telling me it's probably not a hardware problem to begin with). The network card I have is a E2200 Killer Network card btw and I learned online already this was causing some problems for some people.
The only insight I can think of why this would happen is because there is less data transfer in residential zones from less people/mobs around, kicking your network card to shift into this Energy Efficient modus and causing the micro-DC.
So now I'm here posting in the hopes it might help someone else suffering the same problem.