Score:0

How do I calculate how many eDTU I need?

ng flag

I currently have four on-premise SQL Server instances (all replicated) each with between 3 and 5 production databases in them which I want to migrate to a single Azure SQL elastic pool.

How do I calculate how many eDTU I am currently using for my on-premise instances? The Azure DTU calculator which I have seen many references to https://dtucalculator.azurewebsites.net/ appears to be down.

Score:0
ng flag

Solved

  1. The website mentioned above has changed to https://dtucalc.azurewebsites.net/

  2. The script it shares in order to create the log file it needs to analyze your needs didnt work properly for me, it omitted the % Processor Time column (looks like some escape character needed for the "%" character)

logman create counter sql_perflog -c "\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" -si 1 -f csv

So I just commented out the line in their script which deletes the sql_perflog counter after the logging is complete, as below

::logman delete sql_perflog

Then ran the script once so that it created the data collector in Performance Monitor, then opened Performance Monitor (Start -> Run -> perfmon.msc) and navigated to Data Collector Sets -> User Defined where I found sql_perflog and added the % Processor Time column in manually.

enter image description here

Once the logs have been collected for at least an hour, upload to the website mentioned in (1) above and it calculates your requirement.

I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.