--- description: Flash storage often gets the headline when it comes to discussing database performance. However CPUs and RAM are vital components in determining how many... title: Selecting the Best Intel Xeon E5-2600 v2 CPU for SQL Server 2012 image: https://www.storagereview.com/wp-content/uploads/2014/10/StorageReview-Best-Intel-CPU-SQL-Server-2012-Thumb.jpg --- [![Storage Review]()](https://storagereview.com/) --- [Facebook](https://www.facebook.com/@storagereview) [X (Twitter)](https://twitter.twitter.com/storagereview) [Instagram](https://www.instagram.com/storagereview/) [LinkedIn](https://www.linkedin.com/company/storagereview-com) [YouTube](https://www.youtube.com/user/storagereview?sub_confirmation=1) [Email](mailto:info@storagereview.com) [Spotify](https://open.spotify.com/show/1y6VnznABhHeOSMOmbDTz0) [Reddit](https://www.reddit.com/r/StorageReview/) [Discord](https://discord.gg/TwMHb4azdC) [RSS Feed](https://www.storagereview.com/rss.xml) [TikTok](https://www.tiktok.com/@storagereview) [Facebook](https://www.facebook.com/@storagereview) [X (Twitter)](https://twitter.com/storagereview) [Instagram](https://www.instagram.com/storagereview/) [LinkedIn](https://www.linkedin.com/company/storagereview-com) [YouTube](https://www.youtube.com/user/storagereview?sub_confirmation=1) [Email](mailto:info@storagereview.com) [Spotify](https://open.spotify.com/show/1y6VnznABhHeOSMOmbDTz0) [Reddit](https://www.reddit.com/r/StorageReview/) [Discord](https://discord.gg/TwMHb4azdC) [RSS Feed](https://www.storagereview.com/rss.xml) [TikTok](https://www.tiktok.com/@storagereview) [![StorageReview.com](https://www.storagereview.com/wp-content/uploads/2026/07/Storage-Review-2x.png)](https://www.storagereview.com) ≡ Menu - [Home](https://www.storagereview.com/) - [Storage Reviews](https://www.storagereview.com/review) - [End User Reviews](https://www.storagereview.com/consumer) - [Enterprise Reviews](https://www.storagereview.com/enterprise) - [Ubiquiti Reviews](https://www.storagereview.com/best/ubiquiti-reviews) - [SR Merch](https://store.storagereview.com) - [Leaderboards](https://www.storagereview.com/best) - [Best Storage Arrays](https://www.storagereview.com/best/storage-arrays) - [Best Enterprise SSDs](https://www.storagereview.com/best/enterprise-ssds) - [Best Servers](https://www.storagereview.com/best/servers) - [Best Enterprise GPUs](https://www.storagereview.com/best/enterprise-gpus) - [Best Desktops for Local AI](https://www.storagereview.com/best/desktops-local-ai) - [Best Laptops for Local AI](https://www.storagereview.com/best/laptops-local-ai) - [Best Local LLM Tools](https://www.storagereview.com/best/local-llm-tools) - [Agentic AI Hardware](https://www.storagereview.com/best/agentic-ai-hardware) - [Best SSDs & Hard Drives](https://www.storagereview.com/best_drives) - [Best Portable SSDs](https://www.storagereview.com/best/portable-ssds) - [Best Business Laptops](https://www.storagereview.com/best/business-laptops) - [Best Mobile Workstations](https://www.storagereview.com/best/mobile-workstations) - [Best Desktop Workstations](https://www.storagereview.com/best/desktop-workstations) - [Best Mini PCs](https://www.storagereview.com/best/mini-pcs) - [Best Laptop Battery Life](https://www.storagereview.com/best/laptop-battery-life) - [Storage Reference Guide](https://www.storagereview.com/storage-reference-guide) - [About SR](https://www.storagereview.com/about-storagereview) - [StorageReview.com Sweepstakes Rules and Regulations](https://www.storagereview.com/storagereview-com-sweepstakes-rules-and-regulations) Search [Home](https://www.storagereview.com/) » [Review](https://www.storagereview.com/review) » Selecting the Best Intel Xeon E5-2600 v2 CPU for SQL Server 2012 # Selecting the Best Intel Xeon E5-2600 v2 CPU for SQL Server 2012 by Brian Beeler on October 23, 2014 [Enterprise](https://www.storagereview.com/enterprise)  ◇  [Server](https://www.storagereview.com/enterprise/server) 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. ![](https://www.storagereview.com/wp-content/uploads/2014/10/StorageReview-Best-Intel-CPU-SQL-Server-2012.jpg) The question that often comes up when considering a system build is which Intel processor makes the most sense for database workloads. Does the build need more cores or higher clock speed? There's also a cost element: do the additional steps up in CPU net a benefit for this specific workload? To answer these questions we've set out to look at multiple steppings of the Ivy Bridge v2 processor line, from 8 to 12 cores and ranging clock speed from 2.0GHz to 3.4GHz with the objective to find out which offers the best transactional latency.  **Testbed** For this analysis we're evaluating the Intel CPUs within a [Supermicro SuperStorage Server 2027R-AR24NV](https://www.storagereview.com/supermicro_superstorage_server_2027rar24nv_review) running Windows Server 2012, which is 2U dual-socket box that supports the E5-2600 and E5-2600 v2 family of Intel CPUs. The system RAM is comprised of sixteen 16GB Micron PC3-12800 DIMMs that remain static for each CPU tested. We leveraged the 2.6TB  [Fusion ioMemory PX600](https://www.storagereview.com/fusion_iomemory_px600_review) for in-host storage, which has posted very good SQL Server latency numbers (the fastest current-gen product our lab has tested). ![]() Server Configuration - 2x Intel Xeon E5 v2 CPUs - Intel C602 Chipset - Memory – 256GB (16x 16GB) 1600MHz Micron DDR3 Registered RDIMMs (128GB dedicated to system, 128GB dedicated to SQL) - Windows Server 2012 Standard - 3x Supermicro SAS3 HBAs (LSI SAS 3008 Controllers) - 200GB Micron P400m Boot SSD - 1x Mellanox ConnectX-3 Dual-Port VPI PCIe 3.0 Adapter (InfiniBand LoadGen Fabric) - 1x Emulex OCe11102 Dual-Port 10GbE Adapter ![]() Storage Configuration - SanDisk Fusion-io ioMemory PX600 2.6TB - 80% Over-provisioning in high-performance mode - Full power draw enabled - VSL 4.1.1 Firmware/Drivers The CPUs under consideration are two each of the following: - Intel Xeon Processor E5-2640 v2 – 20M Cache, 2.00GHz, 8 cores – $889 - Intel Xeon Processor E5-2687W v2 – 25M Cache, 3.40GHz, 8 cores – $2112 - Intel Xeon Processor E5-2690 v2 – 25M Cache, 3.00GHz, 10 cores – $2061 - Intel Xeon Processor E5-2697 v2 – 30M Cache, 2.70GHz, 12 cores – $2618 The obvious standout in this group is the workstation-class E5-2687W v2 processor. The purpose of this CPU analysis is to determine whether clock speed or core-count was best, the 2687W v2 was included as it is the highest clock speed 8-core+ processor in the E5 v2 family. Outside of purchasing CPUs separately, the workstation-class processors are not offered as an option from most server vendors. That leaves the 3GHz 10-core E5-2690 v2 or the 3.3GHz 8-core E5-2667 v2 (the latter of which wasn't tested) as the highest clock speed offerings for most buyers. **Performance** Each set of two CPUs were tested in the same manner: leveraging our [SQL Server 2012 OLTP benchmark](https://www.storagereview.com/sql_server_oltp_benchmark) with the database sitting on the PX600 inside the single-node 2P Supermicro server. As with most storage devices in the same class, we don't worry so much about transaction per second; the emphasis is really on the latency for each of those transactions to complete. As expected, all four CPUs delivered TPS numbers within a few points. With that said, the processor with the highest clock speed came out in front of the processors with additional cores, or lower clocks peeds. ![]() Turning to latency, which is really what we care about here, the numbers get much more interesting. Of all the Intel Xeon Ivy Bridge v2 processors, the E5-2690 (3.00GHz, 10 cores) and E5-2687W (3.40GHz, 8 cores) posted 2ms latency scores with the Fusion ioMemory PX600. The E5-2697 (2.70GHz, 12 cores) came in next with 5ms followed closely by the E5-2640 (2.00GHz, 8 cores) with 6ms. ![]() **Conclusion** From the information we've gathered in this particular configuration, the resounding message for those building a SQL Server 2012 production server is that clock speed matters more than the number of cores. With all other variables kept equal, we measured higher performance in TPC-C runs from the 8-core 3.4GHz E5-2687W v2 than from the 12-core 2.7GHz E5-2697 v2. Differences in performance were narrowed when compared against the 10-core 3GHz E5-2690 v2, which was able to match 2ms latency figure, although slightly trail in TPS. The difference between the top and bottom though is also nearly $1000 per CPU according to list price. Whether that price delta is worth the 3X improvement in SQL Server latency is dependent on the business needs, or perhaps a CPU set in between is the ideal compromise.  At the end of the day it makes sense to research which components offer the best performance per dollar for your specific workload, so that more educated decisions can be made. For highly virtualized workloads the additional cores can definitely help improve performance to cram additional VMs onto a single server. In the case of SQL Server 2012 running on a physical host though with Ivy Bridge v2 CPUs, clock speed matters more. [Intel Xeon Processor E5-2600 v2 Product Family](http://ark.intel.com/products/series/75291/Intel-Xeon-Processor-E5-2600-v2-Product-Family#@All) Selecting the [Best RAM Configuration for SQL Server 2012](https://www.storagereview.com/selecting_the_best_dram_configuration_for_sql_server_2012) [Discuss This Review](http://forums.storagereview.com/index.php/topic/37166-selecting-the-best-intel-xeon-e5-2600-v2-cpu-for-sql-server-2012-discussion/) **Engage with StorageReview** [Newsletter](https://www.storagereview.com/storage_newsletter) |  [YouTube](https://www.youtube.com/user/StorageReview "Opens in a new window") | Podcast  [iTunes](https://podcasts.apple.com/gb/podcast/storagereview-com-storage-reviews/id1060681115 "Opens in a new window")/ [Spotify](https://open.spotify.com/show/1y6VnznABhHeOSMOmbDTz0 "Opens in a new window") |  [Instagram](https://www.instagram.com/storagereview/ "Opens in a new window") |  [Twitter](https://twitter.com/storagereview "Opens in a new window") |  [TikTok](https://www.tiktok.com/@storagereview? "Opens in a new window") |  [RSS Feed](https://www.storagereview.com/rss.xml) ![]() ### Brian Beeler Brian is located in Cincinnati, Ohio and is the chief analyst and President of StorageReview.com. Previous post: [Fusion ioMemory PX600 Review](https://www.storagereview.com/review/fusion-iomemory-px600-review) Next post: [Fujitsu Storage ETERNUS DX200F Review](https://www.storagereview.com/review/fujitsu-storage-eternus-dx200f-review) Trusted Vendors Products and solutions from our affiliate partners: - [ ![Ubiquiti Logo](https://www.storagereview.com/wp-content/uploads/2024/11/2-1.webp) Ubiquiti ](https://store.ui.com/us/en?a_aid=StorageReview "Opens in a new window") - [ ![Newegg Logo](https://www.storagereview.com/wp-content/uploads/2025/11/newegg.webp) Newegg ](https://click.linksynergy.com/fs-bin/click?id=g5terNMDhz0&offerid=1207190.18&subid=0&type=4 "Opens in a new window") - [ ![Amazon Logo](https://www.storagereview.com/wp-content/uploads/2025/11/amazon.webp) Amazon ](https://amzn.to/4fLJUEW "Opens in a new window") Newsletter Subscribe to the StorageReview newsletter to stay up to date on the latest news and reviews. We promise no spam! 1 Leave this field empty if you’re human: ## Advertisement Content Categories [Facebook](https://www.facebook.com/@storagereview) [X](https://twitter.com/storagereview) [Instagram](https://www.instagram.com/storagereview/) [LinkedIn](https://www.linkedin.com/company/storagereview-com) [YouTube](https://www.youtube.com/user/storagereview?sub_confirmation=1) [Email](mailto:info@storagereview.com) [Spotify](https://open.spotify.com/show/1y6VnznABhHeOSMOmbDTz0) [Reddit](https://www.reddit.com/r/StorageReview/) [Discord](https://discord.gg/TwMHb4azdC) [RSS](https://www.storagereview.com/rss.xml) [TikTok](https://www.tiktok.com/@storagereview) Copyright © 1998-2025 Flying Pig Ventures, LLC Cincinnati, Ohio. All rights reserved. Manage your privacy To provide the best experiences, we and our partners use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us and our partners to process personal data such as browsing behavior or unique IDs on this site and show (non-) personalized ads. Not consenting or withdrawing consent, may adversely affect certain features and functions. Click below to consent to the above or make granular choices. Your choices will be applied to this site only. You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen. Functional Functional Always active The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network. Preferences Preferences The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user. Statistics Statistics The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you. Marketing Marketing The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes. Statistics Marketing Features Always active Special features Special purposes Always active - Manage options - Manage services - Manage {vendor\_count} vendors - [Read more about these purposes](https://cookiedatabase.org/tcf/purposes/) Accept Deny Manage options Save preferences Manage options - {title} - {title} - {title} Manage your privacy To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions. Functional Functional Always active The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network. Preferences Preferences The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user. Statistics Statistics The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you. Marketing Marketing The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes. Statistics Marketing Features Always active Special features Special purposes Always active - Manage options - Manage services - Manage {vendor\_count} vendors - [Read more about these purposes](https://cookiedatabase.org/tcf/purposes/) Accept Deny Manage options Save preferences Manage options - {title} - {title} - {title} Manage consent Manage consent ```json {"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.storagereview.com\/review\/selecting-the-best-intel-xeon-e5-2600-v2-cpu-for-sql-server-2012","url":"https:\/\/www.storagereview.com\/review\/selecting-the-best-intel-xeon-e5-2600-v2-cpu-for-sql-server-2012","name":"Selecting the Best Intel Xeon E5-2600 v2 CPU for SQL Server 2012 - StorageReview.com","isPartOf":{"@id":"https:\/\/www.storagereview.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.storagereview.com\/review\/selecting-the-best-intel-xeon-e5-2600-v2-cpu-for-sql-server-2012#primaryimage"},"image":{"@id":"https:\/\/www.storagereview.com\/review\/selecting-the-best-intel-xeon-e5-2600-v2-cpu-for-sql-server-2012#primaryimage"},"thumbnailUrl":"https:\/\/www.storagereview.com\/wp-content\/uploads\/2014\/10\/StorageReview-Best-Intel-CPU-SQL-Server-2012-Thumb.jpg","datePublished":"2014-10-23T17:55:31+00:00","breadcrumb":{"@id":"https:\/\/www.storagereview.com\/review\/selecting-the-best-intel-xeon-e5-2600-v2-cpu-for-sql-server-2012#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.storagereview.com\/review\/selecting-the-best-intel-xeon-e5-2600-v2-cpu-for-sql-server-2012"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.storagereview.com\/review\/selecting-the-best-intel-xeon-e5-2600-v2-cpu-for-sql-server-2012#primaryimage","url":"https:\/\/www.storagereview.com\/wp-content\/uploads\/2014\/10\/StorageReview-Best-Intel-CPU-SQL-Server-2012-Thumb.jpg","contentUrl":"https:\/\/www.storagereview.com\/wp-content\/uploads\/2014\/10\/StorageReview-Best-Intel-CPU-SQL-Server-2012-Thumb.jpg","width":100,"height":93},{"@type":"BreadcrumbList","@id":"https:\/\/www.storagereview.com\/review\/selecting-the-best-intel-xeon-e5-2600-v2-cpu-for-sql-server-2012#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.storagereview.com\/"},{"@type":"ListItem","position":2,"name":"Review","item":"https:\/\/www.storagereview.com\/review"},{"@type":"ListItem","position":3,"name":"Selecting the Best Intel Xeon E5-2600 v2 CPU for SQL Server 2012"}]},{"@type":"WebSite","@id":"https:\/\/www.storagereview.com\/#website","url":"https:\/\/www.storagereview.com\/","name":"StorageReview.com","description":"StorageReview.com is a leading provider of news and reviews throughout the entire IT stack - from the datacenter to the edge, and all points in between.","publisher":{"@id":"https:\/\/www.storagereview.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.storagereview.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.storagereview.com\/#organization","name":"StorageReview.com","url":"https:\/\/www.storagereview.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.storagereview.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.storagereview.com\/wp-content\/uploads\/2020\/02\/Storage-Reviews-2-2.png","contentUrl":"https:\/\/www.storagereview.com\/wp-content\/uploads\/2020\/02\/Storage-Reviews-2-2.png","width":344,"height":61,"caption":"StorageReview.com"},"image":{"@id":"https:\/\/www.storagereview.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/storagereview","http:\/\/youtube.com\/user\/storagereview"]}]} ```