© Pranab Mazumdar, Sourabh Agarwal, Amit Banerjee 2016

Pranab Mazumdar, Sourabh Agarwal and Amit Banerjee, Pro SQL Server on Microsoft Azure , 10.1007/978-1-4842-2083-2_10

10. Azure SQL Database: Performance and Monitoring

Pranab Mazumdar, Sourabh Agarwal1 and Amit Banerjee1

(1)Bangalore, Karnataka, India

Microsoft Azure SQL Database can be provisioned in different service tiers—Basic, Standard, and Premium—each with multiple performance levels—Basic, S1, S2, P1, P2, etc. Each performance level provides an increasing set of resources, which are designed to deliver increasingly higher transaction throughput.

The resources and transactional power in each service tier and performance level are expressed in terms of Database Throughput Units (DTUs) . ...

Get Pro SQL Server on Microsoft Azure now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.