SQL Server DMA command line : DMACMD Action=SkuRecommendation

Question

.\DmaCmd.exe /Action=SkuRecommendation
/SkuRecommendationInputDataFilePath="C:\TestOut\out.csv"
/SkuRecommendationTsvOutputResultsFilePath="C:\TestOut\prices.tsv"
/SkuRecommendationJsonOutputResultsFilePath="C:\TestOut\prices.json"
/SkuRecommendationOutputResultsFilePath="C:\TestOut\prices.html"
/SkuRecommendationPreventPriceRefresh=true

for the SkuRecommendationInputDataFilePath, it says
Full path to the performance counter file collected from the computer hosting your databases

so for the performance counter, what counter has to be collect ?

Answer 1

Hi @sakuraime ,

The SKU Recommendations feature is available only via the Command Line Interface (CLI).

The first step in the process is to collect performance counters for your databases. You can collect performance counters by running a PowerShell command on the computer that hosts your databases. DMA provides you with a copy of this PowerShell file, but you can also use your own method to capture performance counters from your computer.

You can find the PowerShell file SkuRecommendationDataCollectionScript.ps1 under the folder C:\Program Files\Microsoft Data Migration Assistant on the computer where the DMA tool is installed.

Check the code of this PowerShell file, or run the file in Windows PowerShell ISE then get the .csv file, you can view the counters.

More details please check the document: Identify the right Azure SQL Database/Managed Instance SKU for your on-premises database.