Berechung der mit dem https://dtucalculator.azurewebsites.net/

Ausführen des PS Commands auf englischen Servern:

<#
    .SYNOPSIS
    Collect counters required for DTU Calculator and log as CSV.

    .DESCRIPTION
    Collect counters required for DTU Calculator and log as CSV. 
    Default log file location is C:\sql-perfmon-log.csv.
    Counters are collected at 1 second intervals for 1 hour or 3600 seconds.
    No support or warranty is supplied or inferred. 
    Use at your own risk.

    .PARAMETER DatabaseName
    The name of the SQL Server database to monitor.

    .INPUTS
    Parameters above.
    
    .OUTPUTS
    None.

    .NOTES
    Version: 1.0
    Creation Date: May 1, 2015
    Modified Date: June 17, 2016
    Author: Justin Henriksen ( http://justinhenriksen.wordpress.com )    
#>

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:\sql-perfmon-log.csv" -Force

auf deutschen Servern:

<#
    .SYNOPSIS
    Collect counters required for DTU Calculator and log as CSV.

    .DESCRIPTION
    Collect counters required for DTU Calculator and log as CSV. 
    Default log file location is C:\sql-perfmon-log.csv.
    Counters are collected at 1 second intervals for 1 hour or 3600 seconds.
    No support or warranty is supplied or inferred. 
    Use at your own risk.

    .PARAMETER DatabaseName
    The name of the SQL Server database to monitor.

    .INPUTS
    Parameters above.
    
    .OUTPUTS
    None.

    .NOTES
    Version: 1.0
    Creation Date: May 1, 2015
    Modified Date: June 17, 2016
    Author: Justin Henriksen ( http://justinhenriksen.wordpress.com )    
#>

Set-ExecutionPolicy -Scope Process -ExecutionPolicy Unrestricted -Force

$ErrorActionPreference = "Stop"
$VerbosePreference = "Continue"

cls

Write-Output "Collecting counters..."
Write-Output "Press Ctrl+C to exit."

$counters = @("\Prozessor(_Total)\Prozessorzeit (%)", 
"\Physikalischer DAtenträger(_Total)\Lesevorgänge/s", 
"\Physikalischer DAtenträger(_Total)\Schreibvorgänge/s", 
"\SQLServer:Databases(_Total)\Geleerte Protokollbytes/Sekunde") 

Get-Counter -Counter $counters -SampleInterval 1 -MaxSamples 3600 | 
    Export-Counter -FileFormat csv -Path "C:\sql-perfmon-log.csv" -Force

Danach den Header der deutschen CSV ändern auf:

Interval,% processor time,disk reads/sec,disk writes/sec,log bytes flushed/sec