Dell Inspiron 5480 Laptop Review

I recently had a chance to work on someone’s new Dell Inspiron 5480 laptop recently, doing some memory and storage upgrades. I also installed and patched a fresh copy of Windows 10 Professional, updated the main BIOS, updated the drive firmware, and also installed all of the latest device drivers. This was purposely meant to be a rather modest and affordable system that would still be a decent performer in a relatively small and light form factor.

Original Specifications

As originally configured, this machine had an 8th generation Intel Core i7-8565U (4C/8T) “Whiskey Lake” processor with a base clock speed of 1.80 GHz, a max turbo frequency of 4.60 GHz, and an 8 MB L3 cache. It had one 16 GB stick of DDR4-2666 MHz RAM (with one empty slot), which meant the memory was operating in single-channel mode instead of dual channel mode. For storage, it had a 128 GB SK Hynix BC501 M.2 PCIe 3.0 x2 NVMe drive for the operating system, and a 1TB Seagate ST1000LM035-1RK172 5400 rpm SATA hard drive for extra storage.

These general specifications are a pretty big improvement over a mainstream business laptop from a few years ago. It used to be that machines in this price range would have a 2C/4T processor and a single 2.5” SATA drive bay, probably with a conventional hard drive. Having a 4C/8T processor and two drive bays, one being M.2 PCIe 3.0 x4 NVMe, makes a big difference!


Initial Storage Benchmarks

I wanted to confirm that the machine wasn’t DOA from Dell, so I unboxed it and plugged it in. Everything worked fine out of the box, so I collected some quick CrystalDiskMark results on the two OEM drives. First was the 128GB SK Hynix M.2 PCIe NVMe boot drive. As you can see below, this is quite miserable performance for an M.2 PCIe NVMe SSD.

Sequential Read (Q= 32,T= 1) : 1585.788 MB/s
Sequential Write (Q= 32,T= 1) : 287.443 MB/s
Random Read 4KiB (Q=  8,T= 8) : 277.594 MB/s [67772.0 IOPS]
Random Write 4KiB (Q=  8,T= 8) : 255.548 MB/s [62389.6 IOPS]

Keep in mind that this is a M.2 2230 form factor drive that also only supports two PCIe 3.0 lanes, rather than the four PCIe 3.0 lanes that most M.2 PCIe NVMe drives support. This limits its sequential bandwidth to about 1600 MB/second. It is also a very small capacity drive, which further limits its performance because there are fewer NAND cells than in a larger capacity drive. You really should try to stay away from NAND SSDs that are smaller than 500 GB in size.

Just for comparison, here are the same CrystalDiskMark results for the 1TB Seagate ST1000LM035-1RK172 5400 rpm SATA hard drive that came in the system. Even with a 128 MB cache, these are not impressive results for a laptop hard drive. They are probably better than than the hard drives in many existing laptops, but really, using a conventional magnetic hard drive in a laptop is just a miserable experience that I would avoid unless you have no financial alternative.

Sequential Read (Q= 32,T= 1) : 139.031 MB/s
Sequential Write (Q= 32,T= 1) : 133.234 MB/s
Random Read 4KiB (Q=  8,T= 8) : 1.162 MB/s [283.7 IOPS]
Random Write 4KiB (Q=  8,T= 8) : 1.246 MB/s [304.2 IOPS]

Opening Up the Beast

Once I was done with this initial storage testing, it was time to open up the machine to make some improvements. Working with laptops for hardware modifications can be anywhere from easy to fairly difficult. Some “Ultrabook” style machines are virtually impossible to work on, with non-replaceable components or components that are soldered in place. Just getting them opened without breaking or damaging anything can sometimes be pretty challenging. I recommend that you download the service manual for your machine before you even buy it to make sure you understand what you will be dealing with. I also recommend having proper tools from IFixit.com.

I would rate the difficulty of opening up the Dell Inspiron 5480 as medium. There are three captive phillips screws, and seven removeable phillips screws that must be loosened or removed from the base. After that comes the fun part of getting the plastic base to pop off without breaking anything or damaging the plastic surface. IFixit has a number of “prying and opening tools” that are made of carbon fiber or plastic, so you can open things like this without damaging them.


DSC01361

Figure 1: Inside of Dell Inspiron 5480 with OEM Drives


DSC01363

Figure 2: Inside of Dell Inspiron 5480 with Samsung 970 EVO Plus


After opening up the case, I added a 16GB DDR4-2666 SODIMM that I had purchased for $64.99 at Micro Center. Next, I removed both OEM drives, and I installed the 500GB Samsung 970 EVO Plus M.2 2280 PCIe NVMe drive. I had to move a small retaining clip to a different position because the new drive used the longer 2280 form factor (which means it is 80mm long rather than 30mm long). I purposely did not install the 1TB Samsung 860 EVO SATA SSD at this time, because I was going to be installing a fresh copy of Windows 10. In my experience, Windows 10 will sometimes (without asking) install some things on a second drive if it is present during the initial installation, so I always have just a single physical or logical drive present at this point.


DSC01365

Figure 3: Installing Windows 10 (the first time)


As it turned out, I ended up having to install Windows 10 twice because of how Dell had the storage BIOS settings configured from the factory. They had the storage in RAID mode (which uses Intel storage drivers), which seemed to work and perform decently. The only problem with that was that this confused the Samsung Magician software, which claimed that the Samsung 970 EVO Plus was not supported (which prevented me from using Samsung Magician to check for and install firmware updates on the drive). Switching the BIOS to AHCI mode made Windows 10 refuse to boot, so I just reinstalled it from scratch rather than try to fix it. After getting Windows 10 Professional installed, patched, and upgraded to Version 1903, I was ready to continue.

Upgraded Storage Benchmarks

Once everything was installed, patched, and updated, I ran a fresh set of CrystalDiskMark tests on both new drives. First was the new boot drive, which is the 500GB Samsung 970 EVO Plus. As you can see, this was a huge improvement over the original 128GB SK Hynix drive, especially for write performance!

Sequential Read (Q= 32,T= 1) : 3561.355 MB/s
Sequential Write (Q= 32,T= 1) : 3035.333 MB/s
Random Read 4KiB (Q=  8,T= 8) : 710.060 MB/s [173354.5 IOPS]
Random Write 4KiB (Q=  8,T= 8) : 370.695 MB/s [90501.7 IOPS]

Next was the 1TB Samsung 860 EVO SATA SSD that replaced the 1TB Seagate 5400 rpm hard drive. Again, this was a huge improvement over the OEM hard drive. It also shows how much better a good M.2 PCIe NVMe SSD is compared to a SATA AHCI SSD.

Sequential Read (Q= 32,T= 1) : 561.795 MB/s
Sequential Write (Q= 32,T= 1) : 511.736 MB/s
Random Read 4KiB (Q=  8,T= 8) : 398.251 MB/s [97229.2 IOPS]
Random Write 4KiB (Q=  8,T= 8) : 340.293 MB/s [83079.3 IOPS]

Conclusion

For less than $1200.00 (including the upgraded memory and storage), my friend has a pretty capable machine. It has good CPU performance with a relatively modern Intel 4C/8T processor, 32GB of RAM, and 1.5TB of flash storage. It could easily be upgraded to 64GB of RAM, and up to 6TB of flash storage in the future. It also has a modern 802.11ac WiFi radio and a decent amount of USB 3.0 ports and other connectors. This is not a “top of the line machine”, but it will give a good enough user experience for several years.





SQL Server 2014 Hardware Analysis Case Study

Imagine that you have been given the go-ahead to upgrade your entire data platform stack from SQL Server 2008 Enterprise Edition to SQL Server 2014 Enterprise Edition. You need to come up with a recommendation for your new database server hardware, looking to maximize performance while controlling your SQL Server 2014 license costs.

To help you with that effort, here is an example hardware analysis comparing an existing legacy four-socket server (a Dell PowerEdge R815) with four AMD Opteron 6168 processors to a new four-socket server (a Dell PowerEdge R920) with newer 22nm Intel Xeon E7 v2 Ivy Bridge-EX processors.

For a Dell PowerEdge R920, I would be looking at one of these three processors:

1. Xeon E7-8857 v2   (12 cores, 3.0 GHz base clock speed)

2. Xeon E7-8891 v2   (10 cores, 3.2 GHz base clock speed)

3. Xeon E7-8893 v2   (6 cores, 3.4 GHz base clock speed)

These three candidate processors all have higher base clock speeds and lower physical core counts than some other more common choices, such as the fifteen-core Xeon E7-4890 v2.

The closest equivalent AMD-based system I could find in the TPC-E benchmark results (to the legacy system) was an HP ProLiant BL685c G7 Blade Server with four, 2.2GHz AMD Opteron 6174 processors and 512GB of RAM, with an actual raw TPC-E score of 1464.12. The raw TPC-E score is a good way of measuring the overall CPU capacity of a system.

Dividing this score by the number of physical cores in the system gives us a score/core of 30.5, which is a good measure of single-threaded processor performance. Since the legacy system has slower 1.9GHz AMD Opteron 6168 processors (from the same generation and family), we simply need to adjust for the clock speed difference. Taking 1.9GHz divided by 2.2 GHz is 0.8636. Taking the actual 1464.12 score times 0.8636 gives us an estimated TPC-E score of 1264.46 for the legacy system. Dividing that by 48 physical cores gives an estimated score/core of 26.34 for the legacy system.

There is an actual TPC-E result for a four-socket IBM System x3850 X6 with four, 15-core 2.8GHz Intel Xeon E7-4890 v2 processors and 2TB of RAM, with a raw TPC-E score of 5576.27. Dividing this actual score by 60 physical cores gives us an actual score/core of 92.94.

We can adjust this actual result for the three candidate processors listed above to take into account the difference in core counts and base clock speeds to get estimated TPC-E scores for a four-socket system with each of those processors since they are from the same generation and family.

1. Xeon E7-8857 v2               5576.27 original score, times .80 (core count difference), times 1.0714 (clock speed difference), is 4779.53 divided by 48 total physical cores is 99.57 score/core

2. Xeon E7-8891 v2               5576.27 original score, times .66 (core count difference), times 1.1428 (clock speed difference), is 4233.73 divided by 40 total physical cores is 105.84 score/core

3. Xeon E7-8893 v2               5576.27 original score, times .40 (core count difference), times 1.2142 (clock speed difference), is 2708.28 divided by 24 total physical cores is 112.84 score/core

Comparing the legacy system to the actual new four-socket TPC-E result and my estimates for the other three processors, gives us this summary:

Processor                        TPC-E Score        Score/Core         Total Physical Cores     SQL 2014 License Cost (EE)

Opteron 6168                    1264.46                 26.34                     48                             $329,952.00     ($274,464.00 with AMD Core Factor discount)

Opteron 6174                    1464.12                 30.50                     48                             $329,952.00     ($274,464.00 with AMD Core Factor discount)                        

Xeon E7-4890 v2               5576.27                 92.94                     60                             $395,942.00

Xeon E7-8857 v2               4779.53                 99.57                     48                             $329,952.00       

Xeon E7-8891 v2               4233.73                 105.84                   40                             $274,960.00

Xeon E7-8893 v2               2708.28                 112.84                   24                             $164,976.00

This means that we could choose from having from roughly four times better single-threaded processor performance using the Xeon E7-8893 v2 processor or from having roughly four times more processor capacity using the Xeon E7-8857 v2 processor in a new system compared to the legacy system, depending on which processor we choose. The difference in SQL Server 2014 Enterprise Edition license costs between the different processor choices is quite dramatic. For example, going from the twelve-core processor to the faster ten-core processor lowers your SQL Server license costs by about as much as the actual server would cost.

Bigger Database Servers Get Faster

For quite some time, I have been talking about how current Intel-based four-socket database servers have had significantly lower single-threaded processor performance than current Intel-based two-socket database servers. This is because the first generation Intel Xeon E7 processors were using the relatively old 32nm Westmere microarchitecture that was introduced in early 2011 for the initial Xeon E7 (Westmere-EX) product line.

These E7 processors also use much lower base and turbo clock speeds than current Xeon E5 v2 processors, which also hurts their single-threaded processor performance. They do have higher overall concurrent load capacity due to higher total memory capacity and more total processor cores, but the individual processor cores in most four-socket servers have been much slower than what you find in a modern two-socket server. Simply put, bigger servers are not faster servers. It is like comparing an eighteen wheeler truck to a Tesla Model S.

Now, that old assessment is going to change somewhat, with the release of the 22nm Intel Xeon E7 Processor v2 Family (Ivy Bridge-EX), and new model servers from the major server vendors that have even higher memory capacity, PCI-E 3.0 support, and 12Gbps SAS/SATA support, along with much faster RAID controllers. These processors are a substantial improvement over the previous generation 32nm Intel Xeon E7 processors (Westmere-EX) that have been available since early 2011.

It will still be possible to configure a new two-socket server, such as a Dell PowerEdge R720, with an appropriate 22nm Intel Xeon E5-2600 Processor v2 Family (Ivy Bridge-EP) processor that will have better single-threaded performance than a new four-socket server such as a Dell PowerEdge R920, but the gap will not be nearly as large as it once was.

The actual good news here for a database professional is the fact that you will be able to have a four-socket server that has as much load capacity as a previous generation, eight-socket server, that also performs nearly as well as a current two-socket server, while paying 25% less for your SQL Server 2012/2014 license costs (compared to a previous generation eight-socket server). This is a pretty big gift from Intel!

A more pessimistic view is that your SQL Server 2012/2014 license costs could rise by 50% as you move from an existing server equipped with four, ten-core Xeon E7-4870 processors (with a total of forty physical cores) to a new server with four, fifteen-core Xeon E7-4890 v2 processors (with a total of of sixty physical cores). For reasons known only to Intel, the lower core count SKUs in the Xeon E7-48xx v2 product family are not “frequency optimized”, meaning they do not have higher clock speeds than the high-end, E7-4890 v2 processor. The base and turbo clock speeds of the best lower core-count SKUs in the E7- 48xx v2 family actually drop off pretty quickly as the core counts go down. The shared-L3 cache sizes also drop off very quickly, as does the processor price, as you can see in Table 1.

Processor Physical Cores L3 Cache Base Clock Turbo Clock Price
E7-4890 v2 15 37.5 MB 2.8GHz 3.4GHz $6,619.00
E7-4860 v2 12 30 MB 2.6GHz 3.2GHz $3,838.00
E7-4830 v2 10 20 MB 2.2GHz 2.7GHz $2,059.00
E7-4820 v2 8 16 MB 2.0GHz 2.5GHz $1,446.00
E7-4809 v2 6 12 MB 1.9GHz N/A $1,223.00

Table 1: Selected Intel E7-48xx v2 Processors

 

With the Xeon E4-48xx v2 product family, you are going to want to choose either the E7-4890 v2 or the E7-4860 v2 model processors in most situations, since the lower core count processors are giving up a substantial amount of performance due to their lower clock speeds and smaller L3 cache sizes. If you really want to reduce your core counts to reduce your SQL Server 2012/2014 license costs, you would be better off with the Intel Xeon E5-26xx v2 product family processors that are used in two socket servers. Another alternative is the upcoming Intel Xeon E5-46xx v2 product family processors that are used in four-socket servers.

Either of those choices would be better than one of the lower core count processors in the E7-48xx v2 product family, at least from a pure processor performance perspective.

Intel also has refreshed the E7-88xx v2 product family that is meant for eight-socket and larger servers. For some reason (probably for HPC use), Intel does have “frequency-optimized”, lower core-count models in this product family, as you can see in Table 2.

Processor Physical Cores L3 Cache Base Clock Turbo Clock Price
E7-8890 v2 15 37.5 MB 2.8GHz 3.4GHz $6,841.00
E7-8857 v2 12 30 MB 3.0GHz 3.6GHz $3,838.00
E7-8891 v2 10 37.5 MB 3.2GHz 3.7GHz $6,841.00
E7-8893 v2 6 37.5 MB 3.4GHz 3.7GHz $6,841.00

Table 2: Selected Intel E7-88xx v2 Processors

 

I could see some scenarios where you might want to get an eight-socket server with the six-core E7-8893 v2, so that you could have the same physical core count, while having double the memory capacity and much better single-threaded processor performance than a four-socket server with the twelve-core E7-4860 v2. The hardware cost would be significantly higher, since you would be buying eight processors for $6,841.00 each instead of four processors at $3,838.00 each, but for many organizations, that would not be a major issue.

Some server vendors may offer the Xeon E7-88xx v2 processors in their four-socket server models, since they are pin-compatible, which would give us a lot more flexibility as far as processor selection goes. I really wish Intel had “frequency-optimized” models in their Xeon E7-48xx v2 product family, to make this even easier.