DTU Calc gives error when uploading file

Question

We are trying to migrate our sql server 2022 database to azure and we tried this DTU calculator

https://dtucalc.azurewebsites.net/

We ran the script on our VM and when we upload the generated file we get:

Error! One or more headers missing from file. Ensure the following are present: '% Processor Time', 'Disk Reads/sec', 'Disk Writes/sec', 'Log Bytes Write/sec'

Anyone knows why?

Answer 1

I didn't want to spend time changing settings etc. Instead I wrote this in PowerShell and it works now. For anyone out there having any issues with the script you can use the below

$Counters = @(
    "\Processor(_Total)\% Processor Time",
    "\LogicalDisk(_Total)\Disk Read Bytes/sec",
    "\LogicalDisk(_Total)\Disk Write Bytes/sec",
    "\LogicalDisk(_Total)\Disk Reads/sec",
    "\LogicalDisk(_Total)\Disk Writes/sec",
    "\Database(svchost)\Log Bytes Write/sec"     
)

# Continuous monitoring with a specified sample interval
$Interval = 1  # seconds
$FilePath = "C:\MigrationMetrics\output.csv"

Get-Counter -Counter $Counters -Continuous -Interval $SampleInterval | Export-Counter -Path $FilePath -FileFormat CSV

Answer 2

Hi
pantonis •,

Welcome to Microsoft Q&A forum.

Please follow the instructions mentioned here: https://justinhenriksen.wordpress.com/2015/09/29/introducing-the-azure-sql-database-dtu-calculator-part-2/

and

https://sqlperformance.com/2019/04/sql-performance/sending-sentryone-data-to-azure-sql-database-dtu-calculator

also ensure you run the PowerShell script as administrator.  If not, you may see errors about missing counters.

Let us know if this helped or you have further queries.

Thanks

Answer 3

I know it may sound weird, but could you try to set the language of the computer where you are creating the CSV to English US on the Regional Settings, and try generating the CSV again.