Azure SQL - Transaction rate per hour Explained

In Programming Tags #azure #sql-server Published 12/4/2014

I was examing the SQL Server offerings that Azure provides and was having trouble finding answers to what some of the metrics meant on each tier, specifically the "Transaction rate per hour" or "Transaction rate per minute". My programming brain immedidately associated "Transaction" with an official database transaction.

In terms of this metric the transaction for this calculation consists of all SELECT, UPDATE, INSERT and DELETES. Further, each of these will be sub categorized based on how much processing each one takes (e.g. simple selects will be weighted less than complex ones).

The best descriptions I could find were here:

http://msdn.microsoft.com/library/azure/dn741336.aspx#benchmark

This link has a good analysis on the pros/cons/price performance of some of the database tiers:

https://cbailiss.wordpress.com/2014/07/06/microsoft-azure-sql-database-performance-tests-summary/

Leave a comment

Please note that we won't show your email to others, or use it for sending unwanted emails. We will only use it to render your Gravatar image and to validate you as a real person.