Azure's MSSQL service performance test

Azure gives us a lot of service and these services can make it easy for businesses to build a robust service system. However, when using Azure related product services, there should be some simple performance understanding of the related services to better enable enterprises to buy their own service products. MSSQL is a service delivered by azure Product, it offers multiple performance levels for the user to choose from, but gives you some insight into some performance descriptions; Below is a simple test that looks at the concurrency of Mmsql on Azure for several levels of P1,P2 and P3 for the enterprise.

Test Cases

Test the database for Northwind for stress testing, with the following specific test cases:

• random get orders and related details

  int i =            System.Threading.Interlocked.Increment (ref mindex)%morderids.count;            int OrderID = Morderids[i]; (Model.Orders.orderID = = OrderID).            Listfirst<model.orders> (CC); if (DB = = Peanut.DB.DB2 | | DB = = Peanut.DB.DB3) {using (Peanut.dbcontext.changetable<model.orderdetails> ("' Order Det Ails ' ")) {(Model.OrderDetails.orderID = = OrderID).                List<model.orderdetails> (CC); }} else {(Model.OrderDetails.orderID = = OrderID).            List<model.orderdetails> (CC); }

• add employee

  string id = guid.newguid ().            ToString ("N");            Model.employees item = new Model.employees (); Item.            Address = "GZ" +ID; Item.            City = "GZ"; Item.            Country = "CN"; Item.            Region = "GD"; Item.            Title = "Programmer"; Item.            BirthDate = DateTime.Now.AddYears (-10); Item. HireDate = Item.            Birthdate.adddays (20); Item.            FirstName = "Fan"; Item.            LastName = "Henry"; Item.            Notes = ID; Item. Save (cc); 

• get top 10 of customer orders

  int i = System.Threading.Interlocked.Increment (ref mindex)% Mcustomers.count;            String CustomerID = Mcustomers[i];            Peanut.sql SQL;            if (DB = = Peanut.DB.DB2 | | DB = = Peanut.DB.DB3)            {                SQL = "SELECT * from Northwind. Orders where [email protected] limit 0,10 ";            }            else            {                SQL = "SELECT Top ten * from Orders where [email protected]";            }            Sql["P1", CustomerID]. List<model.orders> (CC);

• Add orders and details (transactions)

  Orders order = new orders (); Order.                EmployeeID = memployeesid[memployeeindex% memployeesid.count]; Order.                CustomerID = mcustomersid[mcustomerindex% mcustomersid.count]; Order.                ShipVia = mshippers[mshippersindex% mshippers.count]; Order.                Freight = 94.5m; Order.                OrderDate = morderdatetime[morderdatetimeindex% morderdatetime.count]; Order. RequiredDate = order.                Orderdate.adddays (30); Order. ShippedDate = order.                Orderdate.adddays (30); Order.                shipaddress = "GZ ld"; Order.                ShipCity = "GZ"; Order.                ShipCountry = "cn"; Order.                ShipName = "SDFSDF"; Order.                Shippostalcode = "510500"; Order.                ShipRegion = "GD"; Order.                Save (CC); int orderid = SQL.                Getvalue<int> (CC);                int items = mdetails[mdetailsindex% mdetails.count];            int pindex = Mproductindex;    for (int i = 0; i < items; i++) {pindex++;                    Products Product = mproducts[pindex% mproducts.count];                    OrderDetails detail = new OrderDetails (); Detail.                    OrderID = OrderID; Detail. ProductID = product.                    ProductID; Detail.                    Quantity = 5; Detail. UnitPrice = product.                    UnitPrice; Detail.                    Discount = 0.8; if (DB = = Peanut.DB.DB2 | | DB = = Peanut.DB.DB3) {using (peanut.dbcontext.changetable<model.orderdetails > ("Order Details")) {detail.                        Save (CC); }} else {detail.                    Save (CC); }} cc.commit ();

Test results

• P1
  
  
• P2
  
  
• P3
  
  

Summarize

Judging from the test results is enough for a common application, but for some relatively high-concurrency Internet companies, it's probably a bit stressful. However, when planning can consider primary and secondary business separation to the business core storage to MSSQL and read support by the NoSQL service products to support, after all, Azure also provides other storage service options. But from the price of P3 cost is relatively high, in the domestic is probably 3W more than one months, this price can actually build linux+mariadb in Azure will get a more ideal performance. (Next you'll test the processing power of Azure linux+mariadb)

Download the test code

Azure's MSSQL service performance test