So this isn't strictly SBA material, but some of the decision points are going to be similar. It's more of a configure-to-order versus a build-to-order.
Background: My job responsibilities are shifting a little bit to include inventory analyst type activities. As such I'm going to be doing more reporting and number crunching on larger datasets than before. Longer-term (18+ months) our corporate IT is working on some big-iron BI tools, but that's a ways off. For now, I've been given a task of speccing out a new system to use for local data-warehousing of our ERP data, as well as a machine that can handle the number-crunching.
Environment: It will most likely sit in the server room with RDP access only
IT Systems: We are primarily a Lenovo shop; all the laptops as well as the engineering/CAD machines are Lenovo
A couple configurations I've run:
Lenovo Thinkstation R920
2x Xeon 4114 10-core CPU's
48GB ECC DDR4 RAM (6x8gb) - I'd prefer to fill all the slots, so we might do 12x8gb
2x512GB SSD in RAID-1 - Many of the files will be stored on the network shares, so this will primarily be for database storage
3-yr same-day on-site support - mucho important IMHO
10Gbe card - this can't be configured through Lenovo, but the Intel X710 will be a good option. I need to work with IT to make sure they have a spare SFP port.
The other one I've looked at is the straight server chassis.
Something like the Dell R540:
This would let me step up to much bigger CPU's. Something like the dual Xeon 6130 16-core. This would be about 8x the processing power of my current laptop.
GPU needs would be bare minimum.
SQL needs are going to be large datasets, but fewer access. Most of the access will be from myself and maybe the other analyst. Once we have the data warehouse setup, there will be reports that will run off of that by ~50 users with simple queries.
Any thoughts or comments?