BLOG

Azure SQL Database DTU Calculator

09-08-2019  0 Comment(s)

 Azure SQL Database. If so, you've probably asked yourself, "which service tier and performance level should I use and how many database throughput units (DTUs) am I using now?" This calculator will help you determine the number of DTUs for your existing SQL Server database(s) as well as a recommendation of the minimum performance level and service tier that you need before you migrate

Azure SQL Database

Measure resource utilization

To measure resource utilization for your database server, you'll need to capture several performance metrics on your SQL server. To provide the most accurate measurement, you should run a representative production workload during a time period that captures the expected range of usage. Measure the following utilization metrics for at least an hour so the calculator can analyze utilization over time to provide you the best recommendation:

  • Processor - % Processor Time
  • Logical Disk - Disk Reads/sec
  • Logical Disk - Disk Writes/sec
  • Database - Log Bytes Flushed/sec

To assist in capturing the correct performance metrics, use one of the following utilities (Command Line EXE or PowerShell Script) to capture your database utilization. The utility and script are configured to capture the above performance counters for a one hour period.

  • Before running the utility/script, ensure that no processes other than SQL are utilizing CPU, memory, and disk.
  • Click the link and download the zip file on to your SQL server and extract the contents.
  • If you are using the command line utility, right-click the .exe file and select "Run as administrator."
  • If you are using the PowerShell script, navigate to the Windows PowerShell ISE and right-click to "Run as administrator." Within Windows PowerShell ISE, browse to the sql-perfmon.ps1 script file and click 'F5' to run the script.

Comment Here

Comments

No Comments to Show

WE ALWAYS WORK WITH :