Enterprise Reviews
by Kevin OBrien

Selecting the Best DRAM Configuration for SQL Server 2012

Building the ideal Microsoft SQL Server 2012 production server can be a daunting task, with variables such as storage, RAM, or processor selection stumping even seasoned IT administrators. We last posted an analysis around selecting the best Intel Xeon E5-2600 v2 CPU for running SQL Server 2012 in non-virtualized environments. Aside from CPU, RAM is another key component when considering performance needs of SQL running on iron. For this testing we used the same testbed as the Intel processor study, this time focusing on stepping Micron PC3-12800 RAM with the best-performing CPU and storage to gauge its performance impact. 

Read more
by StorageReview Enterprise Lab

EMC Data Domain DD2200 Review (DD Boost for SQL)

The EMC Data Domain DD2200 is a deduplication appliance for backup and archive data that is designed for small to midrange data centers. A recent addition to the Data Domain line, the DD2200 consolidates backup, archive, and disaster recovery into one easy-to-manage 2U rack unit platform. The device is offered in two configurations: either a 7 drive system with 7.5TB of usable space or a 12 drive system with 17.2TB of usable space. The DD2200 supports up to 4.7TB per hour throughput and can support up to 860TB of logical capacity via expansion shelves. 

Read more
by StorageReview Enterprise Lab

Fujitsu Storage ETERNUS DX200F Review

The Fujitsu Storage ETERNUS DX200F is a 2U all-flash storage array (AFA) that is designed to work in concert with fast servers and network connections to service the needs of the most demanding applications. The DX200F can run 5-24 SAS3 drives of either 800GB or 1.6TB for an overall raw capacity of up to 38.4TB. The array comes with a 16Gb Fibre Channel, an optional 10Gb iSCSI interface card, 16GB cache, integration of system management tools from VMware and Microsoft Hyper-V, and complementary ETERNUS SF Express management software (a unified management suite across Fujitsu's line that provides enterprise-class functionality to even entry- and midrange-class products). All major components are redundant, including the power supply and storage controller, allowing for continuous operations and component swaps during an unplanned outage.

Read more
by Brian Beeler

Selecting the Best Intel Xeon E5-2600 v2 CPU for SQL Server 2012

Flash storage often gets the headline when it comes to discussing database performance. However CPUs and RAM are vital components in determining how many transactions SQL Server can handle, and more importantly, how quickly it can deliver them. For those running SQL 2012 on iron (non-virtualized) as many are, architecting the system can be a delicate balance between capacity, performance and cost considerations. In this review we evaluate four Intel Xeon Ivy Bridge v2 processors and their effect on SQL TPC-C workloads in a two processor system.

Read more
by StorageReview Enterprise Lab

Fusion ioMemory PX600 Review

The Fusion ioMemory PX600 is a third-generation PCIe application accelerator with an emphasis on endurance and price-to-performance. The PX600 and its value-oriented SX300 sibling comprise Fusion's new "Atomic Series" which is essentially one hardware platform with two different NAND overprovisioning schemes that result in different performance and endurance profiles for the two drives. Therefore we will be publishing reviews of the two drives in tandem.

Read more
by StorageReview Enterprise Lab

Fusion ioMemory SX300 Review

The Fusion ioMemory SX300 is a third generation PCIe application accelerator with an emphasis on endurance and price-to-performance. The SX300 and its higher-performance PX600 sibling comprise Fusion's new "Atomic Series" which is essentially one hardware platform with two different NAND overprovisioning schemes that result in different performance profiles for the two drives.

Read more
by Lyle Smith

Supermicro SuperServer 1027R-WC1NRT (NVMe) Review

The Supermicro SuperServer 1027R-WC1NRT is a high-performance, enterprise-class server with storage emphasis that supports SAS3 12Gb/s and NVMe interfaces. The chassis houses 10 hot-swappable 2.5" drive bays in a slim, 1U rackmount form factor that is ideal for dense computing environments. The 1027R-WC1NRT is made up of two main subsystems: the SC116AC2-R700WB 1U chassis and the X9DRW-CTF31 dual processor serverboard. In addition, the SuperServer is built around the X9DRWCF31/CTF31, a dual processor serverboard based on the Intel C602J chipset, which is designed to provide the performance needed for intense server workloads.

Read more
by StorageReview Enterprise Lab

HP ProLiant DL360p Gen8 Server Review

The HP DL360p Gen8 is a leading 1U server designed to support the needs of both large data centers that require the compute density that this versatile server offers as well as small and medium sized businesses that appreciate and want to leverage the value and reliability the Gen8 server platform. While the DL360p has been very recently replaced with the DL360 Gen9, those looking for excellent enterprise value without the need for the highest-end computer power will find good value in the HP Gen8 servers as well as its enhanced serviceability and configuration flexibility. 

Read more
by StorageReview Enterprise Lab

EMC VNXe3200 Review

The EMC VNXe3200 unified hybrid array brings VNX engineering, functionality, and enterprise support services to SMBs and ROBOs with a starting price of $11,500. That combination makes the VNXe3200 array accessible for customers that may have been priced out of the VNX lineup in the past. Unlike most other VNX offerings, the VNXe3200 uses a compact 2U form factor that integrates controllers and storage making it more suitable than prior VNX offerings for hub and spoke deployments like retail point-of-sale storage and offsite replication. 

Read more
by StorageReview Enterprise Lab

Emulex LPe16202 Dual-Port CFA Review

The Emulex LPe16202 dual-port Converged Fabric Adapter (CFA) is based on the same hardware as the LightPulse Gen 5 Fibre Channel (FC) cards we reviewed in December of last year, with the addition of supporting Ethernet as well as FC modes. The LPe160202 provides the flexibility to run Gen 5 (16Gb), Advanced-8 (8Gb) Fibre Channel, or 10GbE Fibre Channel over Ethernet (FCoE) connectivity with one adapter. The new Gen 5 Fibre adapters (as well as the LPe16004 quad-port Gen 5 (16GFC) FC HBA and LPe15004 quad-port low-profile Gen 5 (8GFC) HBA) can be used as either host initiators or storage targets in order to achieve superior latency. Additionally, with its claimed reliability and maximized I/O performance and bandwidth, it has the ability to fully realize the power of virtualization, private cloud, and emerging flash cache solutions in servers, arrays, and appliances.

Read more