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

Building an Intel Haswell Desktop System for SQL Server 2012 Development

The 22nm 4th generation Intel Core desktop processors (aka Haswell) have been available for sale for a couple of months now, so I have had some requests to put together a suggested component list for a desktop system that would be suitable for SQL Server 2012 development and testing usage. As you may know, the […]

The Accidental DBA (Day 3 of 30): Hardware Selection: Solid State Drives and Usage

This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a little taster to let you know what we cover in our¬†Immersion Event for The Accidental/Junior DBA, which we present¬†several times each year. If you know someone who would benefit from […]

A SQL Server Hardware Tidbit a Day – Day 19

For Day 19 of this series, I am going to talk a little about RAID, which stands for Redundant array of independent disks or Redundant array of inexpensive disks, depending on who you believe. RAID is a technology that allows the use of multiple hard drives, combined in various ways, to improve redundancy, availability and […]

A SQL Server Hardware Tidbit a Day – Day 18

For Day 18 of this series, I am going to talk about the Intel 910 series PCI-E device that was released back in May of 2012. It is available in 400GB and 800GB capacities. The 400GB model has a suggested retail price about $2000.00 while the 800GB model has a suggested retail price of about […]

A SQL Server Hardware Tidbit a Day – Day 17

For Day 17 of this series, I am going to talk about the Intel DC S3700 series of 6Gbps MLC SATA SSDs. The DC S3700 series is available in 100GB, 200GB, 400GB, and 800GB capacities. The DC S3700 uses 25nm HET-MLC NAND technology, which means that you get higher write endurance than standard MLC consumer […]

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

Intel Flash Storage Products for SQL Server

Intel has recently introduced a couple of flash-based storage products that are aimed at the Enterprise and server market. These are both quite price competitive with some of the other storage products in the marketplace. The first is the Intel 910 series that was released back in May of 2012. It is a PCI-E device […]

Building a Workstation for SQL Server 2012 Development and Testing

With the current crop of high-performance and very affordable desktop computer components, it is not very difficult to assemble an extremely high performance workstation for SQL Server 2012 development and testing at a very reasonable cost. Depending on how much of a purist you are and what your available budget is, you can take several […]