Analyzing and Improving I/O Subsystem Performance Precon in Denver

On September 18, 2015, I will be presenting Analyzing and Improving I/O Subsystem Performance as an all day pre-conference session the day before SQLSaturday #441 in Denver. This session should be a lot of fun and will be very useful for SQL Server database administrators and other I.T. professionals who work with SQL Server. Here […]

New Benchmark Feature in CPU-Z 1.73

Franck Delattre has released CPU-Z 1.73, which adds more Windows 10 support, an L4 cache frequency display (useful for some Intel Broadwell processors), and a CPU Benchmark tab, that lets you run a very quick single-threaded CPU benchmark and a multi-threaded CPU benchmark. This benchmark test takes about 14-15 seconds on my workstation. There is […]

Windows Power Plan Effects on Newer Intel Processors

I recently was working with a customer who had purchased a new Lenovo ThinkServer RD640 with two 22nm Intel Xeon E5-2697 v2 Ivy Bridge-EP processors. This processor was introduced in Q3 of 2013, and it is one generation behind the latest Intel Xeon E5-2600 v3 series processors. This server had a new, default installation of […]

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 […]

TPC-E Single-Threaded Performance Leaderboard

Fujitsu recently posted a new TPC-E benchmark result of 3777.08 for SQL Server 2014, using a two-socket server with the 18-core, 22nm Intel Xeon E5-2699 v3 (Haswell-EP) processor. This is the highest ever actual TPC-E score for a two-socket server, which sounds quite impressive on the surface. One thing that I have been doing for […]

Getting the Best Performance From an Intel DC P3700 Flash Storage Card

I recently had the opportunity to work on a new Dell PowerEdge R720 system that has two, 2TB Intel DC P3700 PCIe Flash Storage Cards installed. This particular card is the largest capacity model of the high-end P3700 series (Intel has lower-end P3600 and P3500 cards in this same family). As with most flash storage, […]

New Versions of Useful Tools for SQL Server

There is a completely rewritten version of Geekbench, which is a very useful cross-platform processor and memory performance benchmark that you can use for comparing and validating processor and memory performance on anything from your laptop to a very expensive database server in just a few minutes, with no configuration of the benchmark needed. As […]

Using TPC-E OLTP Benchmark Scores to Compare Processors

One of the things I do at SQLskills is paid consulting for customers who are looking to upgrade their database servers to new hardware, a new operating system, and a new version of SQL Server. Part of this process is a comparison of the estimated TPC-E score of the existing system compared to the estimated […]

New AMD-based TPC-E Benchmark Result

HP recently submitted a TPC-E benchmark result for a two-socket HP ProLiant DL385p Gen 8 system that is using two 2.8GHz AMD Opteron 6386SE, 16-core processors. This system had a score of 1416.37 TpsE, which does not sound too bad until you compare it to a very similar two-socket HP ProLiant DL380p Gen 8 system […]

A SQL Server Hardware Tidbit a Day – Day 30

For the final post in this series, I want to list a few resources that you can use to help stay current with what is happening in the world of server hardware and storage. I really think that a database professional has a professional responsibility to know the details of their database server hardware and […]

A SQL Server Hardware Tidbit a Day – Day 21

For Day 21 of this series, I want to talk a little bit about the TPC-E OLTP benchmark. The TPC Benchmark E (TPC-E) is an OLTP performance benchmark that was introduced in February 2007. TPC-E is a not a replacement for the older TPC-C benchmark, but rather is a completely new OLTP benchmark. It is […]

A SQL Server Hardware Tidbit a Day – Day 10

For Day 10 of this series, I am going to talk a little bit about disk performance and one easy benchmark tool that you can use to quickly compare the performance of different types of disks and disk arrays. CrystalDiskMark, which is available from Crystal Dew World is a fairly well-known disk subsystem benchmark. You […]