Category: Azure

AzureDatabase

Azure SQL Database DTU Calculator

When considering an Azure SQL instance, one of the decisions you need to make is the pricing level (Basic, Standard or Premium) and then for the selected level the number of DTU’s you need. Now you might be asking, "which service tier and performance level should I use and how many database throughput units (DTUs) am I using now?" 

First lets look at explaining what a DTU is and then we can look at how the DTU Calculator will help.

What are Database Transaction Units (DTUs)?

“A DTU is a unit of measure of the resources that are guaranteed to be available to a standalone Azure SQL database at a specific performance level within a standalone database service tier. A DTU is a blended measure of CPU, memory, and data I/O and transaction log I/O in a ratio determined by an OLTP benchmark workload designed to be typical of real-world OLTP workloads. Doubling the DTUs by increasing the performance level of a database equates to doubling the set of resource available to that database.”

How can I determine the number of DTUs needed by my workload?

If you are looking to migrate an existing on-premises or SQL Server virtual machine workload to Azure SQL Database, you can use the DTU Calculator to approximate the number of DTUs needed.

Following the instructions for the DTU Calculator, download either the Command Line Utility or PowerShell Script and run it to measure your server resource utilization. You want to get an hour worth of data.

Once the script completes, go to the DTU Calculator website and enter in the number of cores for your server and then upload the CSV file that was generated. Then click on the “calculate” button as show below.

image

After the DTU Calculator measures your server resource utilization, it will provide you the best recommendation for the number of DTU’s you should be using in Azure SQL.

Resources

AzureDevelopment

Real World Usage for Azure Functions

Came across an excellent blog post from @TroyHunt on using Azure Functions to track abusive IP addresses to a website and log them to an Azure storage account and then have another Azure Function on a timer to validate those IP addresses and block them if necessary.

https://www.troyhunt.com/azure-functions-in-practice/

Enjoy!

AzureCloud

Azure Monitor

This week saw the announcement of the public preview of Azure Monitor. Azure Monitor allows you to manage and explore all common tasks from a single view. Azure Monitor provides the following types of data – Activity Log, Metrics and Diagnostics Logs.

You can access the Azure Portal by clicking on the Monitor tab in the Azure Portal.

1eeeafee-e790-4ee8-bb11-58c925e01b24

Enjoy!