This may be a bit non-typical, but I am currently running SQL 2019 Developer on my old gaming rig, and I've hit the point where I need to migrate it to a stronger machine.
Has anyone got any hardware tips for running a standalone 2019 instance that won't for the most part be connecting to anything but localhost at most?
I do a lot of analysis of government data and the files/logs/indexes etc are at the point where I just need more beef and so I need to pick a good CPU/Motherboard/Drive etc. Given that I am not servicing customers or even remote or in-network workstations my needs are pretty minimal. Anyone have any experience doing this sort of thing and if so any hardware recommendations on cpu/motherboard/drives etc?
My data is self-ETL'd (mostly flat files via bcp) but the datasets are not that small (85m records in some resultsets) and performance is terrible currently on queries. I've been adding indexes (and frequently having to clear logs) where necessary but its at the breaking point now and the hardware has to change.
Any feedback would be lovely.