Need assistance? I'm here to help.
Need assistance? I'm here to help.
You're wondering if upgrading your server is necessary given the current options. It's understandable to feel uncertain, especially with the price tag on new processors like the 7950X3D. For your setup—OLTP workloads and mainly SQL Server—consider whether a newer chip would truly improve performance or just add marginal gains. The existing hardware might already handle the load well, especially if you're running SAP alongside many clients. Upgrading could be costly without guaranteed benefits, especially if your current system is still performing adequately. It's wise to weigh the costs against your specific needs before making a decision.
ECC RAM is available on some Xeon models, but many AMD chips don’t support it, and most systems using those chips don’t include it.
Some random details about the quality of scilicon for AMD. The Thredripper chips aren't top-tier binned scilicon, but they manage through sheer core count. For 24/7 use, a Ryzen or Intel consumer chip should handle it without problems.
Server quality components perform consistently, though I see you weigh them against their demands and stress levels. Ordinary users with standard NAS or home servers rarely face the intense loads these items are built for. Consumer-grade CPUs meet our demands round the clock without problems. My Plex system has operated continuously for four years now. A basic Ryzen 1600 delivers solid performance in a professional setting—handling 100x to 1000x more tasks than typical home setups. Commercial or industrial options serve specific purposes, so consider your actual needs before deciding.
Sure, I won't be misled by fake ECC RAM support claims. I'll pick boards that actually support it. I already have a few RDIMMs in mind.
And consider basic market share resistance. Xeon has consistently been promoted as essential for business requirements, and Intel’s sales approach is solid (they were indeed the first with business-grade chips). Do you require a Xeon? Unlikely. I only use Xeons when they offer PCIe lanes and ECC support. Scalability matters to me—running dual or quad Xeons is a nice perk—but it’s not essential. Just for fun!
I understand I need to rely on SQL Server for all 25 clients, which means it's intended for business purposes. How can my customers gain from a quick server while keeping costs reasonable for me? This is the question I'm trying to solve, since some sources suggest avoiding low-speed cores for SQL but high-speed CPUs are costly. I'm uncertain if the workload justifies those expenses over five years. Even with a total system budget of €5-7k, losing data would be very serious, so I plan to invest in top NVMe storage and a RAID 10 configuration along with ample RAM. What about the rest of the setup?
These are users who link to the server, such as 25 terminals instead of 25 customers. Apologies for the mix-up.