Originally Posted by
StuckInYYZ
I don't think I've encountered a full SQL instance that couldn't use a reboot every month. One client was funny though. They ran a three node SQL cluster. Every 2-3 months a random node would go offline. The DBA who previously managed their SQL for them said that was normal. I just happened to be there to drop off some goodies (as they were relatively new) and heard this. No patches for at least a year, transaction logs were full (not sure for how long) and they had just rebooted a downed node. Had one of my DBAs purge the logs and set up resourcing restrictions (and other cleanup tasks). Got them to try having my team maintain their cluster for two months (eg, patching with failover, purging logs and other things).... it's been a year and a half since and haven't heard of any issues since.
Honestly, since I did the conversion and DB optimization, I've not done a single thing to the DB other than backing it up every other day. That was Feb 2020. It just runs, so I just leave it alone. Now that we're discussing it, I'll probably poke at it tomorrow and see how it's doing. No user complaints whatsoever.
Actually that brings up one thing. Which would you recommend I learn first (need to learn both). XCP-NG or Proxmox? Curious... a lot of the vloggers are flogging proxmox with one or two promoting XCP-NG so interested in finding out what non-vloggers would suggest.
I've never seen Proxmox in a production environment. It has a lot of nice features, especially being able to run ZFS natively, and having the console built in, but that's about it. Citrix XenSever (and XCP-NG) are found in production environments. They're meant for clustering and all sorts of other goodness. DO compile a XenOrchestra instance from source. The features are amazing. Live Migration's fantastic, as it being able to dump the whole VM as a single file. XCP-NG + TrueNAS is a beautiful combo if you've got the resources to put it together.