I recently had to do an analysis of a client’s database workload using the Azure DTU Calculator(DTU Calculator) and thought it might be interesting to share just how I did that. I have run this tool numerous times on other clients via the PowerShell method and the Command Line method, however this client’s environment was: Windows Server 2008R2, and SQL Server 2008R2 SP3 and had to be done differently.
Now, from the DTU Calculator page itself, it tells you how the process works. It essentially runs a perfmon trace for an hour with the following counters:
- Processor – % Processor Time
- Logical Disk – Disk Reads/sec
- Logical Disk – Disk Writes/sec
- Database – Log Bytes Flushed/sec
My client did not have PowerShell accessible for me to use unfortunately. I normally prefer the PowerShell script, however in this case I had to use the Command Line Interface, they both return the same results.
Click through to see how Jim did it.