{"id":819,"date":"2013-08-02T18:56:31","date_gmt":"2013-08-03T01:56:31","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/glenn\/?p=819"},"modified":"2019-07-29T14:03:46","modified_gmt":"2019-07-29T21:03:46","slug":"building-an-intel-haswell-desktop-system-for-sql-server-2012-development","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/building-an-intel-haswell-desktop-system-for-sql-server-2012-development\/","title":{"rendered":"Building an Intel Haswell Desktop System for SQL Server 2012 Development"},"content":{"rendered":"

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 desktop Haswell processors use Socket 1150, which is incompatible with the older Socket 1155 that was used in the previous desktop 32nm Sandy Bridge and 22nm Ivy Bridge processors.<\/p>\n

That means you will have to get a new motherboard to use a Haswell processor. You should get a Z87 chipset motherboard so that you can get a nice feature set with the motherboard. You want to make sure you get a motherboard that has four memory slots, instead of two, so you can have 32GB of RAM. You also want to pay attention to how many total SATA III ports you are getting. The Z87 chipset natively supports six SATA III ports (with hardware RAID support), and many motherboards will have an extra Marvell controller that can support either two or four more SATA III ports (with hardware RAID support). Having SATA III support is vital for modern SATA III solid state drives.<\/p>\n

This system will have an Intel Core i7-4770K<\/a> quad-core\u00a0 processor (plus hyper-threading), and 16GB of RAM (which can be expanded to 32GB of RAM for about $129.00 more). You could also back down to an Intel Core i5-4670K<\/a> processor, which is a quad-core without hyper-threading. The Core i5 has a slightly lower base and Turbo clock speed and a smaller 6MB L3 cache compared to the Core i7, but it is $80.00 less at Micro Center. Both of these processors have Intel HD Graphics 4600 integrated graphics, which save you the cost and extra power usage of getting a discrete video card. You would probably have to spend about $100.00 to get a discrete video card that has better performance than the Intel HD Graphics 4600 integrated graphics, and I just don\u2019t think you will need to do that for normal desktop usage.<\/p>\n

This system will have better CPU and memory performance than many older production database servers (although you are limited to 32GB of RAM). Depending on what you want to do with this system, you may need or want to add additional SATA III SSDs or conventional hard drives. If you skip the optical drive, you can add seven more drives to this system before you run out of drive bays and SATA III ports. With enough fast SSDs, you may have better I\/O performance (under a light load) than many production database servers. On the other hand, you won\u2019t have redundant components (such as dual power supplies) like you would have with a rack-mounted database server. You will also have SATA consumer-level SSDs that cannot handle a heavy server workload with consistent performance as well as expensive enterprise-level SAS SSDs.<\/p>\n

Below, I have links to the manufacturer information about each component, along with links to the components at Micro Center and NewEgg.<\/p>\n

Motherboard<\/span><\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Gigabyte GA-Z87X-UD4H<\/a>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Micro Center\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NewEgg<\/a><\/p>\n

This Gigabyte motherboard has a total of eight SATA III slots between two separate controllers, with hardware RAID support (with no cache memory). In my experience, Gigabyte motherboards typically let you install server operating systems (including Windows Server 2008 R2 or Windows Server 2012) without any driver issues. Another alternative would be Windows 8 Professional, with Hyper-V, so you can run Windows Server 2012 in VMs. Micro Center is currently selling these for an insanely low sale price of $114.99, plus you get $40.00 more off the motherboard when you buy it with an eligible processor. Update: This motherboard actually uses an Intel NIC, that Intel (in their infinite wisdom) does not allow you to install the NIC drivers on a server operating system, such as Windows Server 2012.<\/strong><\/p>\n

Processor<\/span><\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Intel Core i7-4770K<\/a>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Micro Center\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NewEgg<\/a><\/p>\n

This is the \u201ctop of the line\u201d Haswell desktop processor, with an unlocked multiplier. It is also the main Core i7 processor that Micro Center carries and is eligible for their $40.00 motherboard\/processor bundle discount. It does support VT-x with Extended Page Tables for hardware virtualization support, but it does not support VT-d for directed IO with virtualization. If you are really concerned about VT-d, you can always get an Intel Core i7-3770<\/a> (that does have VT-d) from NewEgg or Micro Center. It will cost $309.99 at New Egg or $249.99 at Micro Center, and you would not get the motherboard bundle discount from Micro Center. I would say that with a decent number of good SSDs, you are much less likely to have any I\/O bottlenecks with virtualization.<\/p>\n

Power Supply<\/span><\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Corsair CX500M<\/a>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Micro Center\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NewEgg<\/a><\/p>\n

This is a high-quality, modular power supply that can easily support a system like this. It has an 80 Plus Bronze efficiency rating, which is pretty good. A lower wattage power supply is more efficient at lower output levels than a higher wattage power supply, so a power supply like this will save you money over time and be less expensive to buy.<\/p>\n

Case<\/span><\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Fractal Design Define R4<\/a>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Micro Center\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NewEgg<\/a><\/p>\n

These Fractal Design cases get universally excellent reviews, and they are very easy to work on when you are building the system, with excellent cable management features. They are also very quiet, with sound deadening foam inside. This case has eight 2.5\u201d\/3.5\u201d drive bays and two USB 3.0 ports on the top front of the case. It does not have any silly gaming features.<\/p>\n

Memory<\/span><\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Crucial Ballistix Sport 16GB DDR3-1600<\/a>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Micro Center\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NewEgg<\/a><\/p>\n

This is pretty decent memory that is eligible for the $10.00 bundle discount from Micro Center when you buy it with a motherboard. NewEgg\u2019s price is actually a little cheaper on this one item. You could also spend more money on higher speed memory, which you may or may notice that much benefit from in real life.<\/p>\n

System Drive<\/span><\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 256GB Samsung 840 Pro SSD\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Micro Center<\/a>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NewEgg<\/a><\/p>\n

These are one of the top consumer SSDs available right now, with lots of good reviews. I have bought a number of these and they are very fast. They are also eligible for a $20.00 bundle discount from Micro Center when you buy them with a motherboard or processor.<\/p>\n

Optical Drive<\/span><\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 24X LG DVDRW\u00a0 OEM<\/a>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Micro Center\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NewEgg<\/a><\/p>\n

I still like to have an optical drive, even though I rarely use it. If you have an external USB optical drive, you can use that to install the OS, or you could use a thumb drive.<\/p>\n

As you can see below, if you are lucky enough to live near a Micro Center, you can save a significant amount of money by getting all of these components from Micro Center instead of NewEgg. You will have to pay sales tax at Micro Center, while you probably won\u2019t at NewEgg. Most of the components (except the case) have free shipping from NewEgg.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Item<\/strong><\/td>\nModel<\/strong><\/td>\nMicro Center Price<\/strong><\/td>\nNewEgg Price<\/strong><\/td>\n<\/tr>\n
Motherboard<\/td>\nGigabyte GA-Z87X-UD4H<\/td>\n114.99 \u2013 40.00 Bundle<\/td>\n189.99 w\/FS<\/td>\n<\/tr>\n
Processor<\/td>\nIntel Core i7-4770K<\/td>\n279.99<\/td>\n339.99 w\/FS<\/td>\n<\/tr>\n
Power Supply<\/td>\nCorsair CX500M<\/td>\n59.99 \u2013 10.00 MIR<\/td>\n69.99 \u2013 10.00 MIR<\/td>\n<\/tr>\n
Case<\/td>\nFractal Design Define R4<\/td>\n89.99<\/td>\n99.99 + 9.99 Ship<\/td>\n<\/tr>\n
Memory<\/td>\nCrucial Ballistix Sport<\/td>\n129.99 \u2013 10.00 Bundle<\/td>\n115.99 w\/FS<\/td>\n<\/tr>\n
System Drive<\/td>\n256GB Samsung 840 Pro<\/td>\n239.99 \u2013 20.00 Bundle<\/td>\n239.99 w\/FS<\/td>\n<\/tr>\n
Optical Drive<\/td>\n24X LG DVDRW\u00a0 OEM<\/td>\n15.99<\/td>\n17.99 w\/FS<\/td>\n<\/tr>\n
Total<\/td>\n<\/td>\n850.93<\/strong><\/td>\n1073.92<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

I\u2019ll also have a post up in the near future that talks about how to build an Intel Sandy Bridge-E or Intel Ivy Bridge-E system, that can have six-cores (plus hyper-threading) and 64GB of RAM. One of those systems will be considerably more expensive, due to a more expensive motherboard, more expensive processor, and more RAM.<\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,145,20,31,156,34],"tags":[162,172,173],"class_list":["post-819","post","type-post","status-publish","format-standard","hentry","category-sql-server-hardware","category-haswell","category-intel","category-sql-server-2012","category-sql-server-2014","category-ssd","tag-haswell-desktop-system","tag-micro-center","tag-newegg"],"yoast_head":"\nBuilding an Intel Haswell Desktop System for SQL Server 2012 Development - Glenn Berry<\/title>\n<meta name=\"description\" content=\"Describes how to select components to build an Intel Haswell desktop system for SQL Server 2012\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/building-an-intel-haswell-desktop-system-for-sql-server-2012-development\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Building an Intel Haswell Desktop System for SQL Server 2012 Development - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Describes how to select components to build an Intel Haswell desktop system for SQL Server 2012\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/building-an-intel-haswell-desktop-system-for-sql-server-2012-development\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2013-08-03T01:56:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-29T21:03:46+00:00\" \/>\n<meta name=\"author\" content=\"Glenn Berry\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Glenn Berry\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/building-an-intel-haswell-desktop-system-for-sql-server-2012-development\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/building-an-intel-haswell-desktop-system-for-sql-server-2012-development\/\",\"name\":\"Building an Intel Haswell Desktop System for SQL Server 2012 Development - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"datePublished\":\"2013-08-03T01:56:31+00:00\",\"dateModified\":\"2019-07-29T21:03:46+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"description\":\"Describes how to select components to build an Intel Haswell desktop system for SQL Server 2012\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/building-an-intel-haswell-desktop-system-for-sql-server-2012-development\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/building-an-intel-haswell-desktop-system-for-sql-server-2012-development\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/building-an-intel-haswell-desktop-system-for-sql-server-2012-development\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Building an Intel Haswell Desktop System for SQL Server 2012 Development\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\",\"name\":\"Glenn Berry\",\"description\":\"Semi-random musings about SQL Server performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\",\"name\":\"Glenn Berry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"caption\":\"Glenn Berry\"},\"sameAs\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Building an Intel Haswell Desktop System for SQL Server 2012 Development - Glenn Berry","description":"Describes how to select components to build an Intel Haswell desktop system for SQL Server 2012","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/glenn\/building-an-intel-haswell-desktop-system-for-sql-server-2012-development\/","og_locale":"en_US","og_type":"article","og_title":"Building an Intel Haswell Desktop System for SQL Server 2012 Development - Glenn Berry","og_description":"Describes how to select components to build an Intel Haswell desktop system for SQL Server 2012","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/building-an-intel-haswell-desktop-system-for-sql-server-2012-development\/","og_site_name":"Glenn Berry","article_published_time":"2013-08-03T01:56:31+00:00","article_modified_time":"2019-07-29T21:03:46+00:00","author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/building-an-intel-haswell-desktop-system-for-sql-server-2012-development\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/building-an-intel-haswell-desktop-system-for-sql-server-2012-development\/","name":"Building an Intel Haswell Desktop System for SQL Server 2012 Development - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"datePublished":"2013-08-03T01:56:31+00:00","dateModified":"2019-07-29T21:03:46+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"description":"Describes how to select components to build an Intel Haswell desktop system for SQL Server 2012","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/building-an-intel-haswell-desktop-system-for-sql-server-2012-development\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/building-an-intel-haswell-desktop-system-for-sql-server-2012-development\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/building-an-intel-haswell-desktop-system-for-sql-server-2012-development\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"Building an Intel Haswell Desktop System for SQL Server 2012 Development"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/","name":"Glenn Berry","description":"Semi-random musings about SQL Server performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7","name":"Glenn Berry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","caption":"Glenn Berry"},"sameAs":["https:\/\/www.sqlskills.com\/blogs\/glenn\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/819","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/comments?post=819"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/819\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=819"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=819"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}