We used DS13-v2’s for all clients and scaled down TPC-E workload to 800,000 customers with data size at 800GB.Īzure Blob Cache is the key for the best price/perfįor the first test we used 2 of Premium SSD P30 disks for SQL Server data file and 1 Premium SSD P20 disk for SQL Server log file. On the client side, we placed the client in the same region and availability zone as the server. We used E64s_v3 VM size as the server for this tests which comes with 64 hyper threaded v-cores on 2.3 GHz Intel XEON ® E5-2673 v4 (Broadwell) processor family, 432 GB memory and 1600 GB of Azure Blob Cache capacity. In this article, we will share recommendations to optimize SQL Server performance on Azure VMs based on performance testing with scaled down TPC-E benchmark.Īzure Es_v3 series offer price/perf advantages with the optimized memory to v-core ratios and commonly selected by SQL Server customers. The TPC-E benchmark uses diverse transactions and utilizes wide range of data types with 12 transactions acting on 33 tables all exercising the ACID compliance tests. These transactions cover traditional OLTP processing along with some very light analytic queries. The TPC-E benchmark is a reliable representation of modern OLTP workloads and highly recommended to measure OLTP workload performance. Most of you are running OLTP applications today with read heavy and complex transactions. Reviewed by Bob Ward, Principal Architect Written by Mine Tokus, Senior Program Manager Jamie Reding, Senior Program Manager and Sadashivan Krishnamurthy, Principal Architect
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |