I've never been much of a desktop hardware guy and don't have much time to research so hopefully someone can help.
The short story is that a customer needs to replicate our server based solution onto a workstation form factor which will be transferred to another site.
It can't be a server as it'll never be racked and this workaround is temporary in nature.
The software is MS SQL Server based and will access 6TB of storage that will be local to the workstation.
The client software itself normally runs on a high end HP Z420 workstation so I was thinking the 'server' can also do the same but I'm not sure if it can hold 6TB of fast storage.
In an a perfect world I'd like a single box containing:
- 8 core CPU
- 16 GB RAM
- 2 x 128 GB SSD in Raid 1 for OS and application
- 6 TB of 10k Raid 10 (for performance) disk
Is this possible? If not then whats the next best option to get 6 TB of fastest reads possible with some level of raid/redundancy.