Azure SQL Database DTU Calculator

 If we have a plan to migrate our on-premises SQL Server database or  pool of databases to Azure SQL Databases. We need to check for which we service tier we need to choose first for that particular database(s) in the cloud , to check this we have DTU (Database Transaction Units) calculator

1) Download the below PowerShell script and run it for one hour, chose that particular hour in which you usually see the load

DTU Calculator

Set-ExecutionPolicy -Scope Process -ExecutionPolicy Unrestricted -Force
$ErrorActionPreference = "Stop"
$VerbosePreference = "Continue"
cls
Write-Output "Collecting counters..."
Write-Output "Press Ctrl+C to exit."

$counters = @("\Processor(_Total)\% Processor Time", 
"\LogicalDisk(_Total)\Disk Reads/sec", 
"\LogicalDisk(_Total)\Disk Writes/sec", 
"\SQLServer:Databases(_Total)\Log Bytes Flushed/sec") 
Get-Counter -Counter $counters -SampleInterval 1 -MaxSamples 3600 | 
    Export-Counter -FileFormat csv -Path "C:\Azure\sql-perfmon-log.csv" -Force
style="font-family: verdana;">

2) The above PowerShell will generate a .csv file which contains information about counters

3) Upload that .csv to into “Choose File” and provide the cores, try to give as many cores as this physical server has when it is on on-premises. And click on calculate button.

4) After providing the cores and uploading the .CSV file it will give suggestions  on the service tier like below.

Below



Comments

Post a Comment

Popular posts from this blog

Configuring Always on setup in Microsoft Azure.

Image
I mentioned those steps here in which i face issues, remaining procedure same. 1)       1)  Go to custom deployments in market place of azure and search with below word. active-directory-new-domain . And it shown like below https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/application-workloads/active-directory/ active-directory-new-domain /azuredeploy.json Provide below values to the fields. Please provide values for the domainname and dnsprefix appropriately. domainname : aoag.contoso.com-->name should give this way and contoso.com is compulsory. dnspefix : aoagl location: eastus2 Vnet: adVNET DomainFQDN: aoag.contoso.com(this will come in later part) 3)       After creating above domain VM. Create two “ SQL Server Virtual VMs ”,(chose SQL Server 2017 version don't chose SQL Server 2019 as this version has some issues with SQL IaaS extensions) not regular VM. Search in the market place as “SQL Vir...
Read more

AZCopy-- How to copy files from Azure Storage Blob Container to on-premises local storage drive and folder

Image
 This article will describe about how to copy .bak file or .BACPAC file from Azure Blob Container to your on premises local drive and folder. Here I am only describing about only the command which can be used to fulfil our copy request which AZCopy .  This AZCopy is a command line utility which you can download from the mentioned URL. After you download this to a specific drive and folder you to run this from the command prompt(CMD). Before that we need these things. 1) Create a Azure SQL Database and take the backup to Azure Storage blob container. Once the file ready under azure storage you can run AZCopy command from your on-premises server and you can bring to on premises drive and folder. If you see the image below I am need to give READ,ADD,CREATE,WRITE  permissions based on the requirement. Once you give this permissions and after generating SAS please run AZCopy command from the command prompt of your on premises server.  Please see the last image. And the ap...
Read more