O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding SQL Database Service Tiers

ASD comes in three new tiers: Basic, Standard, and Premium. The older Web and Business editions are still available, but these will be retired in September 2015, so we don’t recommend using them with a new database. Each tier has a maximum database size along with a Database Throughput Unit (DTU) capacity rating. DTU is a proprietary (Microsoft) measure of server power that incorporates CPU, RAM, and IO thresholds. (Further details are available from MSDN here: http://msdn.microsoft.com/library/dn741336.aspx.)

The Basic tier is targeted at small (usually application- or website-specific) data-usage scenarios. It has a maximum database size of 2GB with a performance level fixed at 5 DTUs.

The Standard edition, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required