Looking for a Data Analytics BuildPost Date: 2021-09-20 |
Post Reply ![]() |
Author | |
jc_hv ![]() Newbie ![]() ![]() Joined: 20 Sep 2021 Online Status: Offline Posts: 1 |
![]() ![]() ![]() Posted: 20 Sep 2021 at 7:11pm |
Budget:
3,500 Expectations: Able to run SQL Server, Average Query 500,000 rows, Python and jypter notebook. Basic office use Last several years and is upgradeable. Looking for suggestions on what to swap out or any suggestions flexible on budget. Appreciate the advice. Specifications: Current Cost: $2,840.00 Chassis Model: Digital Storm Velox Exterior Finish: - Standard Factory Finish Trim Accents: - Standard Factory Finish Processor: Intel Core i9-10900X (10-Core) (Boost Up to 4.5 GHz) Motherboard: ASUS Prime X299-A II (Intel X299 Chipset) (Up to 3x PCI-E Devices) (ThunderboltEX Optional) (No SLI) System Memory: 32GB DDR4 3200MHz Digital Storm Performance Series Power Supply: 850W Digital Storm Performance Series (Modular) (80 Plus Gold) Expansion Bay: - No Thanks Optical Drive: - No Thanks Storage Set 1: 1x SSD M.2 (500GB Digital Storm M.2 Performance Series) Storage Set 2: 1x Storage (3TB Seagate / Toshiba) Storage Set 3: - No Thanks RAID Config: - No Thanks RAID Card: - No Thanks Internet Access: High Speed Network Port (Supports High-Speed Cable / DSL / Network Connections) Graphics Card(s): 1x GeForce GTX 1650 4GB Sound Card: Integrated Motherboard Audio HPC Processor: - No Thanks Extreme Cooling: H20: Stage 2: Digital Storm Vortex Liquid CPU Cooler (Dual Fan) (Fully Sealed + No Maintenance) HydroLux Tubing Style: - Not Applicable, I do not have a custom HydroLux liquid cooling system selected HydroLux Fluid Color: - Not Applicable, I do not have a custom HydroLux liquid cooling system selected Cable Management: Premium Cable Management (Strategically Routed & Organized for Airflow) Chassis Fans: Standard Factory Chassis Fans Internal Lighting: Remote Controlled Advanced LED Lighting System (Multiple RGB Color Modes) Airflow Control: - No Thanks Chassis Mods: - No Thanks Noise Reduction: - No Thanks LaserMark: Option Not Available Boost Processor: Stock Factory Turbo Boost Advanced Automatic Overclocking Boost Graphics Card(s): - No Thanks, Please do not overclock my video card(s) Boost OS: - No Thanks, Please do not tweak the services on the operating system Windows OS: Microsoft Windows 10 Home (64-Bit) Recovery Tools: USB Drive - Windows 10 Installation (Format and Clean Install) Virus Protection: Windows Defender Antivirus (Built-in to Windows 10) Office: - No Thanks Mouse Pad: - No Thanks Display: - No Thanks Surge Shield: - No Thanks Speakers: - No Thanks Keyboard: - No Thanks Mouse: - No Thanks Branded Gear: - No Thanks Priority Build: - No Thanks, Ship Within 14-21 Business Days After Order Is Successfully Processed Warranty: Life-time Expert Care with 3 Year Limited Warranty (3 Year Labor & 1 Year Part Replacement) |
|
Tks
Joe |
|
![]() |
|
Cretae ![]() DS Veteran ![]() ![]() Joined: 22 Mar 2010 Online Status: Offline Posts: 7331 |
![]() ![]() ![]() |
I'm a gamer, so I don't have any specific knowledge of what will be best for your use, but I am fairly well informed about the latest tech and what it can do.
First off, I think you might take a very close look at the Ryzen 9 5900X. AMD has been gaining on Intel for several years now, and the 5900X, with 12 cores and 24 threads, and a 64MB cache is superior to the older 10900X by a significant 17%, while at about the same price. https://cpu.userbenchmark.com/Compare/Intel-Core-i9-10900X-vs-AMD-Ryzen-9-5900X/m969950vs4087 Take note that it is faster/stronger on every average score, especially lower memory latency. The Ryzen has a 64MB L3 cache vs intel's 19.5MB. Second, I don't know the computer process that can't benefit by better transfers from storage. The Storage Set 1 you have selected is literally the slowest SSD here. It is a SATA part, while there are NVM Express SSDs available. The Samsung 500GB 980 PRO offers 12 times the read speed, and 9 times the write speed of the SATA part. That will "turbocharge" everything you do from that drive. Your software, for example, will run much faster, and your machine will boot in <30 seconds. IDK if you would not also benefit from faster secondary storage. There are some SSDs available that will outperform any mechanical drive and fit well within your budget. Be selective, though. There are some storage choices that are not very economical compared to online pricing. I also wish to mention that the case you have listed is the second most expensive one here. If you click on the case in the configurator, you will see alternate choices to save some cash. Here is a possible alternate configuration just to show you what could be possible within your budget: https://www.digitalstorm.com/configurator.asp?id=4096054 Again, I'm poorly informed about your specific needs, but this sample build contains upgrades to your selections that would benefit any use IMHO. Hope it helps. ![]() Edited by Cretae - 21 Sep 2021 at 4:34am |
|
![]() |
|
MrCheetah ![]() Groupie ![]() Joined: 09 Mar 2021 Online Status: Offline Posts: 392 |
![]() ![]() ![]() |
I think, @Cretae has a good suggestion.
I do recall seeing the Ryzen 5000 series has one of the lowest latency memory controllers. So, I was going to suggest that as well. Additionally, I never paid super close attention though would believe -- maybe because I was already using an NVMe drive -- but SQL Server indeed performs better with faster storage. The Impact of SSD Selection on SQL Server Performance | AMD What Kind of Disks Should You Use with Microsoft SQL Server 2016? (Part 2) | Heroix Also, plenty of RAM is best as SQL Server should be doing automized caching. How Much Memory Does Microsoft’s SQL Server Need? | Heroix How to determine how much RAM SQL Server will need?| Spaceworks Community With those noted, here's a slightly revised config: 4098726 |
|
• Ryzen 5600X, ROG Strix B550-I, RX 6900 XT, 32GB Vengeance, 960GB MP510
• be quiet 500DX, i7 11700K, ROG Strix Z590-E, RTX 4080 ProArt + RTX 4070 Ti ProArt, 64GB HyperX Fury, 2TB SN850 |
|
![]() |
|
Cretae ![]() DS Veteran ![]() ![]() Joined: 22 Mar 2010 Online Status: Offline Posts: 7331 |
![]() ![]() ![]() |
Thank you, MrCheetah, for clarifying that the RAM upgrade would be a good idea. I didn't feel I should push that in case it was overkill, but I left plenty of room in the budget in case the OP would want to go that way. Your confirmation that it would be a big help is good enough for me.
@jc_hv: MrCheetah has recommended a solid build well within your budget. I think it would meet your needs very well for several years. Every DS custom build is very upgradeable. ![]() |
|
![]() |
Post Reply ![]() |
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You can vote in polls in this forum |