Get Workload analysis Windows Powershell / the command line.
Get Workload Analysis commands
Get-WorkloadAnalysis
Export the Workload Analysis data to a CVS file.
Command parameters
| Parameter | Use |
|---|---|
| -ConnectionName | The SQL Instance Technology name, case insensitive. |
| -StartDate | Used to select the time range. |
| -EndDate | Used to select the time range. |
| -Resource | “CPU”, “Durations”, “Logic Reads”, “Physical Reads”, “Writes”. |
| -Path | The output file saved path. |
| -isSQL2008 | If the SQL version is 2008 or 2008R2, this parameter is required. |
| -DS | The Diagnostic Server address. |
Export the CSV file to the current path
Get-WorkloadAnalysis -connectionname W2K16-SQL16_sqlserver -startdate "2020-10-23 5:30:00" -enddate "2020-10-23 6:30:00" -Resource "CPU"
Export the CSV file to a specific path
Get-WorkloadAnalysis -connectionname W2K16-SQL16_sqlserver -startdate "2020-10-23 5:30:00" -enddate "2020-10-23 6:30:00" -Resource "CPU" -Path "C:\sosse"
The instance is SQL Server 2008 or 2008R2
Get-WorkloadAnalysis -connectionname SQL2008R2SP3_sqlserver -startdate "2020-10-16 2:30:00" -enddate "2020-10-16 6:30:00" -Resource "Reads" -isSQL2008