top of page

Speed up slow MS SQL Server with top notch hardware

Stop trying to hit me and hit me. You may have made a lot of attempts to find the best hardware to speed up your SQL Sever. Rumors say that there is no one-size-fits-all hardware configuration. Although it might be true, you can be sure that the following configuration fits almost any SQL load. Approved by thousands of SQL Server instances running at AppOnFly SQL.



Dell PowerEdge R740xd

  • 2x Xeon Gold 6244 3.6GHz, 8C/16T, Max Turbo 4.4GHz

  • 1536GB RAM, 2666MT/s LRDIMMs

  • BOSS controller card (2x 240GB RAID 1)

  • PERC H740P RAID Controller, 8Gb NV Cache

  • 12x 3.84TB SSD PM883 (Max 24 HDD/SSD, incl. 12 NVMe)

  • Dual, Hot-plug, Redundant Power Supply (1+1), 1100W

  • iDRAC9,Enterprise

  • Broadcom 57416 2 Port 10Gb Base-T + 5720 2 Port 1Gb Base-T

  • 2x Mellanox ConnectX-3 Pro Dual Port 10 GbE SFP+

Good to know:

  • Server Dell PowerEdge R740xd is the most powerfull 2-socket Dell server ever made (may 2020).

  • Xeon Gold 6244 is the most powerfull 8-core intel CPU at the time.

  • Sure you might not need as much memmory as we use at AppOnFly, safely lower the amount to fit your need. Always remember the right memmory channels alingments.

  • Use BOSS card for hypervizor and set number of SSDs to fit your capcacity. 4 is recommended minimum. Use only mirroring RAID1/10 and forget about RAID5/6 configurations.

  • Integrated 10Gbs Broadcom NIC is good, although Mellanox rocks. 2 cards are simply for redundancy.

Looks like too expensive boy with more then usable horsepower? Spin up your SQL Server at AppOnFly for the fraction of the cost.


412 views5 comments

Recent Posts

See All

5 Comments


jarett
jarett
Jun 05

RadioQ is the radio station where the golden hits of the 80s come alive. If you're a fan of music from Michael Jackson to Madonna, you'll find all your favorite tracks here. But RadioQ offers more than just 80s music https://radioq.com/genres/80s . The broadcast features compositions from different decades, so everyone can enjoy a variety of genres. The radio station is designed for those who appreciate quality and diversity in music. Tune in to RadioQ and immerse yourself in the atmosphere of past years, without forgetting the present. Every broadcast brings new musical discoveries. Connect to RadioQ and enjoy the best hits of all time.

Like

Hi everyone,

I recently came across a fantastic article on EssayService that provides a comprehensive guide on writing a research paper.

This detailed guide walks you through the entire process of crafting a research paper, from understanding the purpose and structure to offering valuable tips for conducting research and writing. It emphasizes the importance of selecting a strong topic, developing a clear thesis, and presenting your findings logically and persuasively.

Whether you’re a student aiming to enhance your research skills or a writer looking to refine your academic writing abilities, this resource is incredibly insightful. I highly recommend giving it a read to master the art of writing a research paper and improve your academic performance.

Check out the article…

Like

ClassDoer is a good service company that works for you 24 hours a day and gives you the best results for each student. You are capable of standing up to trouble. The class tour will be helpful to you all the time and to everyone at Do my online course.

Like

Considеring of lеarning trigonomеtry havе two important rеasons. First, trigonomеtry gives you a solid mathеmatical grounding by giving you thе skills you nееd to comprеhеnd anglеs and trianglеs. Thеsе principlеs arе crucial and have many practical implications in other logical and tеchnical fields. Trigonomеtry incrеasеs spatial and logical thinking, which hеlps onе undеrstand gеomеtric rеlations. Thеsе abilitiеs comе in handy whilе attеmpting to solvе problеms, sincе thеy еquip you to dеal with rеal-world obstaclеs rеgarding lеngths, hеights, and anglеs. Whеthеr you dеsirе to work in STEM or improvе your math skills, trigonomеtry training will help you in many aspects of life and business. Considеring trigonomеtry classеs is wisе as they build a foundational understanding for real-world problem-solving. If ovеrwhеlmеd, еxplor…

Like

Angelina Guerra
Angelina Guerra
Nov 18, 2022

¨This server could not prove that it is htmlgw3.apponfly.com; its security certificate expired 2 days ago. ¨ you guys need to fix that problem and ¨ip limit has been reched" i use the trial once and i already reached my limit.

Like
bottom of page