1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Build Advice Any servers nerds on BT?

Discussion in 'Tech Support' started by modd1uk, 21 Jul 2021.

  1. modd1uk

    modd1uk Multimodder

    Joined:
    4 Sep 2006
    Posts:
    3,479
    Likes Received:
    376
    Before I go writing out a detailed post for advice do we have any server nerds on here?

    After advice on buying vs building :O

    Thankssssssssssssssssssss
     
  2. andrew8200m

    andrew8200m Modder

    Joined:
    4 May 2009
    Posts:
    2,284
    Likes Received:
    150
    Depends what it is for.. Some mini details om application and expectations of budget would be ideal so we can ruin expectations with reality and poke holes in to why you want to run a server rather an cloud service should it come to it :D
     
  3. MLyons

    MLyons 70% Dev, 30% Doge. DevDoge Staff Administrator Super Moderator Moderator

    Joined:
    3 Mar 2017
    Posts:
    3,660
    Likes Received:
    1,796
    we do. We also have a fair few over in the discord we actually consulted on the ones used for our servers.
     
  4. deathtaker27

    deathtaker27 #noob

    Joined:
    17 Apr 2010
    Posts:
    2,187
    Likes Received:
    155
    There are plenty of us around here, though I did read BT as BT ISP not the Relix's home
     
  5. Votick

    Votick My CPU's hot but my core runs cold.

    Joined:
    21 May 2009
    Posts:
    2,297
    Likes Received:
    101
    Yep Infrastructure guy here! I'm sure saspro still lurks too
     
    modd1uk and Arboreal like this.
  6. saspro

    saspro IT monkey

    Joined:
    23 Apr 2009
    Posts:
    9,456
    Likes Received:
    281
    Server Guy checking in
     
    Arboreal likes this.
  7. modd1uk

    modd1uk Multimodder

    Joined:
    4 Sep 2006
    Posts:
    3,479
    Likes Received:
    376
    Hello fellow nerds!

    I appreciate you taking the time to reply and offer advice, I'll try and keep it as simple as possible.

    It has to be Windows or they won't support the software :(

    We need a new server to run some software that only runs on Windows (dental software), there are 25 users initially that will slowly creep up, Server 2019 Standard seems to be the best option software wise even though it's pretty pricey especially when you start adding user CALS as Windows 10 won't allow all the connections will it?
    [​IMG]

    That's what the software company sent regarding Server specs. I've been eyeing up the Dell T140, Xeon E-2244G, 16GB RAM, 2x 1TB HDD's (won't get used), PERC H330 RAID controller, with Server 2019 Standard and 25 User CALS it comes to £2495.35 and I still need SSD's for it.

    I know "don't use consumer SSD's in a business environment" but the cost differences are mental, and I feel the life of something like an MX500 is worth a punt given we have a NAS backup anyway.

    Plan was 2x 500GB SSD's in RAID 1 for Windows, and 2x 2TB SSD's in RAID 1 for the data where the dental software will access, the difference SSD's make compared to spinning rust for users using the software is insane.

    Other option is build one, will it be cheaper? There are a few advantages I can think of like none proprietary connections for the PSU being one.

    Advice welcome, FWIW we've been running a Ryzen 1700 Server with an SSD for OS, SSD for DATA (No RAID AT ALL :O) and NAS RAID 1 backup for a number of years with 0 issues.

    Cheers folks!
     
  8. andrew8200m

    andrew8200m Modder

    Joined:
    4 May 2009
    Posts:
    2,284
    Likes Received:
    150
    Knowing what the software does and the expectations of the company who produce the software, have they noted that as a spec for the system that 25 users log in to and then some or is that an expectation on a general/standardised base of say 4 users for example?
     
  9. modd1uk

    modd1uk Multimodder

    Joined:
    4 Sep 2006
    Posts:
    3,479
    Likes Received:
    376
    It says on the system requirements PDF " If you are running a large Dental Practice (more than 15+ users) consider scaling up the configuration."

    But given the Ryzen 1700 system has been running for a few years with no complaints I'd say a Xeon + SSD's was sufficient surely,
     
  10. deathtaker27

    deathtaker27 #noob

    Joined:
    17 Apr 2010
    Posts:
    2,187
    Likes Received:
    155
    Just to add what are your backup plans for the server? How will you monitor it? Rto and rpo should help here to work out the right strategies

    Also do you have an existing server you could run a vm on?
     
  11. saspro

    saspro IT monkey

    Joined:
    23 Apr 2009
    Posts:
    9,456
    Likes Received:
    281
    Never put consumer SSD's in a production server, especially if there's RAID involved.

    Do you have a rack or does it need to be a tower?

    Based on their requirements, it seems like the fairly standard shitty Access Database with maybe a slightly less crappy front end (but I don't hold much hope for that).
    Does it have to be local to the office?
     
  12. sandys

    sandys Multimodder

    Joined:
    26 Mar 2006
    Posts:
    3,907
    Likes Received:
    299
    The fact the spec is assuming RAID and suggesting more drivers would there be some requirement for database IOP performance as well as redundancy so you'd want to run a few drives in your RAID setup for a raid 10 or something rather than just a raid1, or is that old school thinking.
     
  13. modd1uk

    modd1uk Multimodder

    Joined:
    4 Sep 2006
    Posts:
    3,479
    Likes Received:
    376
    Ow do folks. Backup is just on a NAS that's been perfect since it was installed, does nightly backups. We will be doing offsite backups to AWS once a week.

    Given how many people in the same business just run little shiddy servers I don't think it needs to be too overkill, staff just access a DB for bookings, dentists scan xrays in and add notes.

    We have a cabinet with plenty of space that can accommodate a rack or tower server. Yeah it has to be local.
     
    Last edited: 23 Jul 2021 at 11:55
  14. andrew8200m

    andrew8200m Modder

    Joined:
    4 May 2009
    Posts:
    2,284
    Likes Received:
    150
    Plenty of user access by the sounds of it but low volume in terms of concurrent users.

    Enterprise level raid with redundancy is always useful for mirroring the database. I wouldn't go beyond that as you've mentioned a daily back up.

    I think a 4 core 8 thread will be a bit stretched, especially if you do end up with all 25+ users trying to access something at one time. I would personally look at an 8 core 16 thread with 32GB of ram and skimp elsewhere. Making sure the network is up to scratch. 2.5G in to a switch minimum really as you'll only have 100mb average with 25 users all in at once and that will feel pretty clunky.
     
  15. theshadow2001

    theshadow2001 [DELETE] means [DELETE]

    Joined:
    3 May 2012
    Posts:
    5,239
    Likes Received:
    166
    What about just sticking a vm in the cloud? It will make handling things like back up and redundancy easier and you can scale without the headache/cost of migrating hardware. That's very useful if you expect growth but can't predicate the rate of growth.

    Okay I missed this bit. Oh well
     
    Last edited: 23 Jul 2021 at 19:40
  16. saspro

    saspro IT monkey

    Joined:
    23 Apr 2009
    Posts:
    9,456
    Likes Received:
    281
    After a bit of investigation in to the software (& realising it's probably the same software my dentist uses) I was right. It's a glorified Access Database (hence the overkill specs).

    So you're going to need clockspeed over cores and is why they're recommending SSD's as it means they don't need to fix their software to run at an acceptible speed (sorry, always rather cynical when it comes to little software vendors recommendations, I've worked with developers for too long).

    If you went for something like a DL380 Gen 10 with a couple of higher clockspeed 8 core CPU's (as you're licensed for up to 16 physical cores anyway) , 128-256GB RAM, a dual 10GB NIC, then add the extra 2x front HDD bays and add either Enterprise SSD's or a pile of 10k SAS drives in RAID 10 (with hot spares).
    Then run a hypervisor on it and run your app off a VM.

    Should give you the performance you need and plenty of scope for adding additional virtual machines in to the same budget.

    Now the above is at least £15k butis going to save you a load of hassle in the future.
     
    modd1uk and ElThomsono like this.
  17. andrew8200m

    andrew8200m Modder

    Joined:
    4 May 2009
    Posts:
    2,284
    Likes Received:
    150
    2x to 4x the power output of what I was assuming would be the case for 25+ users. That software does sound rather inefficient..
     

Share This Page