--- description: After our first look at EMC's VxRack Node running in HCI mode measuring synthetic workload performance, we turn our attention to SQL Server OLTP... title: "EMC VxRack Node powered by ScaleIO: SQL Server Performance Review (HCI)" image: https://www.storagereview.com/wp-content/uploads/2016/02/StorageReview-EMC-VCE-VxRack-ScaleIO-System-1000-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) - [Consumer 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 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 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) » EMC VxRack Node powered by ScaleIO: SQL Server Performance Review (HCI) # EMC VxRack Node powered by ScaleIO: SQL Server Performance Review (HCI) by StorageReview Enterprise Lab on July 12, 2016 [Enterprise](https://www.storagereview.com/enterprise) After our first look at EMC's VxRack Node running in HCI mode measuring synthetic workload performance, we turn our attention to SQL Server OLTP performance. In this particular test our focus is on application-level latency, instead of completely stressing the system in terms of both CPU and storage I/O. To find out just how well ScaleIO holds up under pressure, we put its HCI configuration head to head against its [phenominal two-layer results](https://www.storagereview.com/emc_vxrack_node_powered_by_scaleio_sql_server_performance_review_2layer) to see if EMC has a few tricks up its sleeve. ![](https://www.storagereview.com/wp-content/uploads/2017/03/StorageReview-EMC-VCE-VxRack-ScaleIO-System-1000.jpg) **VxRack Node (Performance Compute All Flash PF100) Specifications** - Chassis: 2U-4 node - OS: ESXi vSphere 5.5 - Processors Per Node: Dual Intel E5-2680 V3, 12c, 2.5GHz - Chipset: Intel 610 - DDR4 Memory Per Node: 512GB (16x 32GB) - Embedded NIC Per Node: Dual 1-Gbps Ethernet ports + 1 10/100 management port - RAID Controller Per Node: 1x LSI 3008 - SSDs Per Node: 4.8TB (6x 2.5-inch 800GB eMLC) - SATADOM Per Node: 32GBSLC - 10GbE Port Per Node: 4x 10Gbps ports SFP+ - Power Supply: Dual 1600W platinum PSU AC **SQL Server Performance** Each SQL Server VM is configured with two vDisks; 100GB volume for boot and a 500GB volume for the database and log files. From a system resource perspective, we configured each VM with 16 vCPUs, 64GB of DRAM and leveraged the LSI Logic SAS SCSI controller. While our Sysbench workloads tested previously saturated the platform in both storage I/O and capacity, the SQL test is looking for latency performance. Being an HCI configuration, we have one SQL Server VM running on each of the four PF100 VxRack Nodes. At the time this data was collected, we were running ESXi 5.5 on the cluster, whereas our two-layer results were measured inside an ESXi 6.0 environment. This test uses SQL Server 2014 running on Windows Server 2012 R2 guest VMs, being stressed by Dell's Benchmark Factory for Databases. In this test we spread out four 1,500-scale databases evenly across the EMC VxRack Node to illustrate the aggregate performance inside a 4-node VMware cluster.  **SQL Server Testing Configuration (per VM)** - Windows Server 2012 R2 - Storage Footprint: 600GB allocated, 500GB used - SQL Server 2014 - Database Size: 1,500 scale - Virtual Client Load: 15,000 - RAM Buffer: 48GB - Test Length: 3 hours - 2.5 hours preconditioning - 30 minutes sample period **SQL Server OLTP Benchmark Factory LoadGen Equipment** - Dell PowerEdge R730 VMware ESXi vSphere 6.0 Virtual Client Hosts (2) - Four Intel E5-2690 v3 CPUs for 124GHz in cluster (Two per node, 2.6GHz, 12-cores, 30MB Cache)  - 512GB RAM (256GB per node, 16GB x 16 DDR4, 128GB per CPU) - SD Card Boot (Lexar 16GB) - 2 x Mellanox ConnectX-3 InfiniBand Adapter (vSwitch for vMaotion and VM network) - 2 x [Emulex 16GB dual-port FC HBA](https://www.storagereview.com/emulex_lightpulse_gen5_16gb_fibre_channel_hba_review) - 2 x [Emulex 10GbE dual-port NIC](https://www.storagereview.com/emulex_oneconnect_oce11102nt_review) - VMware ESXi vSphere 6.0 / Enterprise Plus 4-CPU - 10GbE Switching Hardware - Front-End Ports: Mellanox SX1036 10/40GbE Switch - Back-End Ports: Cisco Nexus 3164 10/40GbE Switch In the SQL Server TPC-C test, we look for workload balance across the cluster. With four VMs running in steady-state on four VxRack PF100 Nodes in an HCI configuration, we measured performance ranging from 3154.7 TPS to 3155.8 TPS on the low sidel. In aggregate we saw cluster-wide performance measure 12,621.7 TPS on the ScaleIO HCI cluster. Across the board ScaleIO in HCI outpaced the same storage presented to an outside compute cluster in two-layer mode. ![]() Looking at average latency across our 4 SQL VMs, we were surprised to see how well ScaleIO in an HCI configuration compared to two-layer. We've never seen HCI platforms surpass traditional storage with outside compute resources. Most of the time this is caused by compute overhead from the storage components sharing the same compute resources as the workloads. In the case of ScaleIO though, it obviously had no impact, even though we had lower-end CPUs (2.5GHz vs 2.6GHz) in these nodes compared to the servers we used in two-layer testing. Application latency across four VMs ranged from 10ms to 11ms, with an aggregate average of 10.3ms.  ![]() **Conclusion** In our first look at application performance with EMC's ScaleIO VxRack Node in HCI, we are still surprised by just how well it performs. When running the application on the same hardware as the storage resources, ScaleIO software has no negative hit to the workload itself. This is an impressive feat in and of itself, considering other HCI platforms almost always sap a large percentage of CPU resources to manage background processes (some as high as 30%). To that end, our HCI results surpassed those that we measured with ScaleIO in two-layer mode, dropping average latency from 12.5ms average down to 10.3ms. For customers demanding the highest performing hyper-convereged storage solution for SQL Server, ScaleIO just upped the bar again by being the most efficient HCI solution we've ever tested.  [EMC VxRack Node Review: Overview](https://www.storagereview.com/emc_vxrack_node_powered_by_scaleio_review) [EMC VxRack Node Powered By ScaleIO: Scaled Sysbench OLTP Performance Review (2-layer)](https://www.storagereview.com/emc_vxrack_node_powered_by_scaleio_scaled_sysbench_oltp_performance_review_2layer) [EMC VxRack Node Powered By ScaleIO: SQL Server Performance Review (2-layer)](https://www.storagereview.com/emc_vxrack_node_powered_by_scaleio_sql_server_performance_review_2layer) [EMC VxRack Node Powered By ScaleIO: Synthetic Performance Review (2-layer)](https://www.storagereview.com/emc_vxrack_node_powered_by_scaleio_synthetic_performance_review_2layer) [EMC VxRack Node Powered By ScaleIO Review: Synthetic Performance Review (HCI)](https://www.storagereview.com/emc_vxrack_node_powered_by_scaleio_review_synthetic_performance_review_hci) [EMC VxRack Node Powered By ScaleIO: VMmark Performance Review (HCI)](https://www.storagereview.com/emc_vxrack_node_powered_by_scaleio_vmmark_performance_review_hci) [ScaleIO](http://www.emc.com/storage/scaleio/index.htm) [Discuss this review](http://forums.storagereview.com/index.php/topic/39362-emc-vxrack-node-scaleio-sql-server-performance-review-hci/) [Sign up for the StorageReview newsletter](https://www.storagereview.com/storage_newsletter) **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) ![]() ### StorageReview Enterprise Lab Previous post: [Samsung 850 EVO SSD 4TB Review](https://www.storagereview.com/review/samsung-850-evo-ssd-4tb-review) Next post: [EMC VxRack Node Powered By ScaleIO: VMmark Performance Review (HCI)](https://www.storagereview.com/review/emc-vxrack-node-powered-by-scaleio-vmmark-performance-review-hci) 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 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 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\/emc-vxrack-node-powered-by-scaleio-sql-server-performance-review-hci","url":"https:\/\/www.storagereview.com\/review\/emc-vxrack-node-powered-by-scaleio-sql-server-performance-review-hci","name":"EMC VxRack Node powered by ScaleIO: SQL Server Performance Review (HCI) - StorageReview.com","isPartOf":{"@id":"https:\/\/www.storagereview.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.storagereview.com\/review\/emc-vxrack-node-powered-by-scaleio-sql-server-performance-review-hci#primaryimage"},"image":{"@id":"https:\/\/www.storagereview.com\/review\/emc-vxrack-node-powered-by-scaleio-sql-server-performance-review-hci#primaryimage"},"thumbnailUrl":"https:\/\/www.storagereview.com\/wp-content\/uploads\/2016\/02\/StorageReview-EMC-VCE-VxRack-ScaleIO-System-1000-Thumb.jpg","datePublished":"2016-07-12T21:00:38+00:00","breadcrumb":{"@id":"https:\/\/www.storagereview.com\/review\/emc-vxrack-node-powered-by-scaleio-sql-server-performance-review-hci#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.storagereview.com\/review\/emc-vxrack-node-powered-by-scaleio-sql-server-performance-review-hci"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.storagereview.com\/review\/emc-vxrack-node-powered-by-scaleio-sql-server-performance-review-hci#primaryimage","url":"https:\/\/www.storagereview.com\/wp-content\/uploads\/2016\/02\/StorageReview-EMC-VCE-VxRack-ScaleIO-System-1000-Thumb.jpg","contentUrl":"https:\/\/www.storagereview.com\/wp-content\/uploads\/2016\/02\/StorageReview-EMC-VCE-VxRack-ScaleIO-System-1000-Thumb.jpg","width":100,"height":95},{"@type":"BreadcrumbList","@id":"https:\/\/www.storagereview.com\/review\/emc-vxrack-node-powered-by-scaleio-sql-server-performance-review-hci#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":"EMC VxRack Node powered by ScaleIO: SQL Server Performance Review (HCI)"}]},{"@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"]}]} ```