Newby ordering i9. Recipe for disaster?

[dance621]

Hi, looking at these specs. I have ddr4 ram from a previous build I'll be using. Also have a graphics card I might use but the i9 comes with integrated. Am I missing anything? My concern is I have a poor component that will let the whole thibg down.

Will be using PC for sql server queries on a large DB. THANKS!!

Case
PCS SPECTRUM RGB MID TOWER CASE (WHITE/PINK)
Processor (CPU)
Intel® Core™ i9 24-Core Processor i9-13900 (Up to 5.6 GHz) 36MB Cache
Motherboard
ASUS® PRIME B760-PLUS D4 (LGA1700, PCIe5.0, USB 3.2)
Memory (RAM)
4GB Corsair VENGEANCE DDR4 2400MHz (1 x 4GB)
Graphics Card
INTEGRATED GRAPHICS ACCELERATOR (GPU)
1st M.2 SSD Drive
512GB SOLIDIGM P41+ GEN 4 M.2 NVMe PCIe SSD (up to 3500MB/sR, 1625MB/sW)
2nd M.2 SSD Drive
1TB SOLIDIGM P41+ GEN 4 M.2 NVMe PCIe SSD (up to 4125MB/sR, 2950MB/sW)
Power Supply
CORSAIR 450W CV SERIES™ CV-450 POWER SUPPLY
Power Cable
1 x 1.5 Metre UK Power Cable (Kettle Lead)
Processor Cooling
PCS FrostFlow 120 Series RGB High Performance Liquid Cooler
Thermal Paste
STANDARD THERMAL PASTE FOR SUFFICIENT COOLING
Extra Case Fans
2x 120mm Black Case Fan
Sound Card
ONBOARD 6 CHANNEL (5.1) HIGH DEF AUDIO (AS STANDARD)
Network Card
ONBOARD LAN PORT
Wireless Network Card
WIRELESS 802.11N 300Mbps/2.4GHz PCI-E CARD (Special Offer)
USB/Thunderbolt Options
MIN. 2 x USB 3.0 & 2 x USB 2.0 PORTS @ BACK PANEL + MIN. 2 FRONT PORTS

 

[Steveyg]

Yeah this is just a hard no mate

The i9 is a ridiculously hot chip you need highest of the high end cooling and even that isn't enough in certain circumstances. The Motherboard also isn't suitable for dealing with the massive power draw and heat generated from the 13900 and nor is the PSU suitable. That CPU cooler will die very very very quickly trying to cool that CPU

If you let us know what you'll be doing with the machine and how much you have to spend we can help you spec out something to suit your needs and budget but this build above I can't recommend in the slightest

 

[dance621]

Thanks for the reply. The pc is going to be running sql server with a large database. Complex queries are time consuming so trying to make it as fast as possible. They can take an hour or even more. I have 64GB of ddr4 I will be adding (already own). I was attracted to the i9 because of the high benchmark scores. Budget is a max 1200

 

[Steveyg]

Thanks for the reply. The pc is going to be running sql server with a large database. Complex queries are time consuming so trying to make it as fast as possible. They can take an hour or even more. I have 64GB of ddr4 I will be adding (already own). I was attracted to the i9 because of the high benchmark scores. Budget is a max 1200

For an 13900 the lowest I can get it too and still recommend would be £1400, the 5950X could be a very viable option though and it's coming in fairly cheap at the minute although there is no integrated graphics so you would need a GPU to display out.

The 5950X though would really depend on the RAM you have, Ryzen really need very very fast RAM to work at their most optimal capacity so I'd need to know what speed your current RAM is running at?

 

[dance621]

Thanks again. Nothing crazy on the Ram. 4x16Gb Vengeance LPX DDR4 3000mhz

 

[sck451]

SQL Server is very enterprise software with a very enterprise pricing scheme. You pay a licence fee per core. Is that the case for you? If so, you will want to order AMD rather than Intel, because Intel's multi-core advantages come from having lots of smaller, one-thread cores, whereas AMD runs with all the cores being bigger and hyperthreaded.

 

[RichLan564]

SQL Server is very enterprise software with a very enterprise pricing scheme. You pay a licence fee per core. Is that the case for you? If so, you will want to order AMD rather than Intel, because Intel's multi-core advantages come from having lots of smaller, one-thread cores, whereas AMD runs with all the cores being bigger and hyperthreaded.

SQL server Developer edition is free, or if you did want to put it into production can just buy server licence and the correct number of a CALs, its not mandatory to licence per core, depends on the application really as to which way you go.

 

[sck451]

SQL server Developer edition is free, or if you did want to put it into production can just buy server licence and the correct number of a CALs, its not mandatory to licence per core, depends on the application really as to which way you go.

Thanks, that's very helpful.

 

[dance621]

For an 13900 the lowest I can get it too and still recommend would be £1400, the 5950X could be a very viable option though and it's coming in fairly cheap at the minute although there is no integrated graphics so you would need a GPU to display out.

The 5950X though would really depend on the RAM you have, Ryzen really need very very fast RAM to work at their most optimal capacity so I'd need to know what speed your current RAM is running at?

Hi again Steveyg. What motherboard would you pair with the 5950X? 3000 mhz ram. And which cooler? You got me worried im going to fry my chip!

 

[Steveyg]

For a 5950X build and these uses this would be my bare minimum. Note you will need a graphics card to display out so if you have one laying around great but just factor that into any future costs. 3000Mhz RAM should do the job just fine, ideal would be 3600Mhz but 3000Mhz will do a solid job

If I could push the budget more I'd want the H115i cooler over the H100i, I'd want the STRIXX X570 board over the STRIX B550 and I'd want a larger PSU probably around 750W for these purposes but hey it is what it is

Case
CORSAIR 4000D AIRFLOW TEMPERED GLASS GAMING CASE
Processor (CPU)
AMD Ryzen 9 5950X 16 Core CPU (3.4GHz-4.9GHz/72MB CACHE/AM4)
Motherboard
ASUS® ROG STRIX B550-F GAMING WIFI II (DDR4, USB 3.2, 6Gb/s) - ARGB Ready!
Memory (RAM)
8GB Corsair VENGEANCE DDR4 3000MHz (1 x 8GB)
Graphics Card
NONE, I ALREADY HAVE A GRAPHICS CARD
1st M.2 SSD Drive
512GB SOLIDIGM P41+ GEN 4 M.2 NVMe PCIe SSD (up to 3500MB/sR, 1625MB/sW)
Power Supply
CORSAIR 550W TXm SERIES™ SEMI-MODULAR 80 PLUS® GOLD, ULTRA QUIET
Power Cable
1 x 1.5 Metre UK Power Cable (Kettle Lead)
Processor Cooling
CORSAIR iCUE H100i ELITE RGB High Performance CPU Cooler
Thermal Paste
STANDARD THERMAL PASTE FOR SUFFICIENT COOLING
Sound Card
ONBOARD 6 CHANNEL (5.1) HIGH DEF AUDIO (AS STANDARD)
Network Card
10/100/1000 GIGABIT LAN PORT
USB/Thunderbolt Options
MIN. 2 x USB 3.0 & 2 x USB 2.0 PORTS @ BACK PANEL + MIN. 2 FRONT PORTS
Operating System
Windows 11 Home 64 Bit - inc. Single Licence [KUK-00003]
Operating System Language
United Kingdom - English Language
Windows Recovery Media
Windows 10/11 Multi-Language Recovery Image - Unlimited Downloads from Online Account
Office Software
FREE 30 Day Trial of Microsoft 365® (Operating System Required)
Anti-Virus
NO ANTI-VIRUS SOFTWARE
Browser
Microsoft® Edge
Warranty
3 Year Silver Warranty (1 Year Collect & Return, 1 Year Parts, 3 Year Labour)
Delivery
STANDARD INSURED DELIVERY TO UK MAINLAND (MON-FRI)
Build Time
Standard Build - Approximately 8 to 10 working days
Price: £1,221.00 including VAT and Delivery

Unique URL to re-configure: https://www.pcspecialist.co.uk/saved-configurations/amd-am4-gen3-pc/0fxccyX847/

 

[dance621]

For a 5950X build and these uses this would be my bare minimum. Note you will need a graphics card to display out so if you have one laying around great but just factor that into any future costs. 3000Mhz RAM should do the job just fine, ideal would be 3600Mhz but 3000Mhz will do a solid job

If I could push the budget more I'd want the H115i cooler over the H100i, I'd want the STRIXX X570 board over the STRIX B550 and I'd want a larger PSU probably around 750W for these purposes but hey it is what it is

Case
CORSAIR 4000D AIRFLOW TEMPERED GLASS GAMING CASE
Processor (CPU)
AMD Ryzen 9 5950X 16 Core CPU (3.4GHz-4.9GHz/72MB CACHE/AM4)
Motherboard
ASUS® ROG STRIX B550-F GAMING WIFI II (DDR4, USB 3.2, 6Gb/s) - ARGB Ready!
Memory (RAM)
8GB Corsair VENGEANCE DDR4 3000MHz (1 x 8GB)
Graphics Card
NONE, I ALREADY HAVE A GRAPHICS CARD
1st M.2 SSD Drive
512GB SOLIDIGM P41+ GEN 4 M.2 NVMe PCIe SSD (up to 3500MB/sR, 1625MB/sW)
Power Supply
CORSAIR 550W TXm SERIES™ SEMI-MODULAR 80 PLUS® GOLD, ULTRA QUIET
Power Cable
1 x 1.5 Metre UK Power Cable (Kettle Lead)
Processor Cooling
CORSAIR iCUE H100i ELITE RGB High Performance CPU Cooler
Thermal Paste
STANDARD THERMAL PASTE FOR SUFFICIENT COOLING
Sound Card
ONBOARD 6 CHANNEL (5.1) HIGH DEF AUDIO (AS STANDARD)
Network Card
10/100/1000 GIGABIT LAN PORT
USB/Thunderbolt Options
MIN. 2 x USB 3.0 & 2 x USB 2.0 PORTS @ BACK PANEL + MIN. 2 FRONT PORTS
Operating System
Windows 11 Home 64 Bit - inc. Single Licence [KUK-00003]
Operating System Language
United Kingdom - English Language
Windows Recovery Media
Windows 10/11 Multi-Language Recovery Image - Unlimited Downloads from Online Account
Office Software
FREE 30 Day Trial of Microsoft 365® (Operating System Required)
Anti-Virus
NO ANTI-VIRUS SOFTWARE
Browser
Microsoft® Edge
Warranty
3 Year Silver Warranty (1 Year Collect & Return, 1 Year Parts, 3 Year Labour)
Delivery
STANDARD INSURED DELIVERY TO UK MAINLAND (MON-FRI)
Build Time
Standard Build - Approximately 8 to 10 working days
Price: £1,221.00 including VAT and Delivery

Unique URL to re-configure: https://www.pcspecialist.co.uk/saved-configurations/amd-am4-gen3-pc/0fxccyX847/

Thank you. I really appreciate that.