FAQ FAQ  Forum Search   Register Register  Login Login

Looking for a Data Analytics Build

Post Date: 2021-09-20

 Post Reply Post Reply
  Topic Search Topic Search  Topic Options Topic Options
jc_hv View Drop Down
Email address used to purchase matched with forums account email.

Joined: 20 Sep 2021
Online Status: Offline
Posts: 1
  Quote jc_hv Quote  Post ReplyReply bullet Topic: Looking for a Data Analytics Build
    Posted: 20 Sep 2021 at 7:11pm

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.

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)
Back to Top
Cretae View Drop Down
DS Veteran
DS Veteran
Email address used to purchase matched with forums account email.

Joined: 22 Mar 2010
Online Status: Online
Posts: 6631
  Quote Cretae Quote  Post ReplyReply bullet Posted: 21 Sep 2021 at 3:58am
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.


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:


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
Back to Top
MrCheetah View Drop Down

Joined: 09 Mar 2021
Online Status: Offline
Posts: 323
  Quote MrCheetah Quote  Post ReplyReply bullet Posted: 22 Sep 2021 at 11:24pm
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, RTX 3080 FE, 32GB Vengeance, 960GB MP510
• be quiet 500DX, i7 11700K, ROG Strix Z590-E, RTX 3090 FTW3 Ultra, 64GB HyperX Fury, 2TB SN850, iCue H150i Elite Capellix
Back to Top
Cretae View Drop Down
DS Veteran
DS Veteran
Email address used to purchase matched with forums account email.

Joined: 22 Mar 2010
Online Status: Online
Posts: 6631
  Quote Cretae Quote  Post ReplyReply bullet Posted: 24 Sep 2021 at 4:18am
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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

This page was generated in 3.710938E-02 seconds.