FAQ FAQ  Forum Search   Register Register  Login Login

Looking for a Data Analytics Build

Post Date: 2021-09-20

 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
jc_hv View Drop Down
Newbie
Newbie
Avatar
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
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
Back to Top
Cretae View Drop Down
DS Veteran
DS Veteran
Avatar
Email address used to purchase matched with forums account email.

Joined: 22 Mar 2010
Online Status: Offline
Posts: 5694
  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.

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

Joined: 09 Mar 2021
Online Status: Online
Posts: 150
  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
"White lightning": be quiet 500DX white, Asus ROG Strix Z590-E Gaming, Intel Core i7 11700K, 64GB HyperX Fury, EVGA FTW3 Ultra RTX 3090, 2TB WD_Black SN850, Corsair iCue H150i Elite Capellix white
Back to Top
Cretae View Drop Down
DS Veteran
DS Veteran
Avatar
Email address used to purchase matched with forums account email.

Joined: 22 Mar 2010
Online Status: Offline
Posts: 5694
  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 0.046875 seconds.