Wednesday, May 7, 2014

Details of Azure SQL Database Service Tiers and assoicated throughputs

Basic Guide to choosing Azure SQL Databases.

Let us begin with the new acronym DTU. DTU stands for Database Throughput Unit. DTU includes many of the measures such as CPU, memory and read/write rates to a database. DTU provides a guide for the customer to assess the new SQL Database performance levels - Basic, S1, S2, P1, P2,P3. Each of these is designed to provide higher throughput measured as a function of time (Basic in throughputs/hour, Standard(S1,S2) in throughput/minute and Premium (P1,P2 and P3) in throughput/sec.

I wonder whether Microsoft has something for me like throughputs/week!

The following table is from Shawn Bice's blog post.


Here are some throughput/time values tied to service levels:



Microsoft appears to not to say that these are not transaction guarantees for customers but provided to assist  making choices.

 

No comments:

Post a Comment

What is SQLOISIM? What is it used for in SQL Server?

SQLIOSIM is a tool for simulating SQL Server IO. SQLIOSIM performs reliability and integrity tests on the disk systems that SQL Server uti...