Blog Post

Microsoft Data Migration Blog
3 MIN READ

Identify the best Azure SQL Database SKU for your on-premises database by using the Database Migration Assistant

Jim_Toland's avatar
Jim_Toland
Former Employee
Mar 14, 2019

First published on MSDN on Aug 07, 2018

Authored by datamigrationteam@microsoft.com


Migrating your databases to the cloud is a complicated and time-consuming task that involves a lot of variables, such as what to migrate, how to migrate it, and the target and SKU to which you should migrate. Our goal with the Database Migration Assistant (DMA) is to answer these questions and to make your database migration experience simple and effective.

DMA currently supports assessments and migrations to Azure. In addition, DMA will support:

    • Azure SQL Database SKU recommendations, which identifies the best Azure SQL Database SKU for your on-premises databases (released August 2018).
    • Scale assessments, which allow you to perform assessments at scale to get target\Azure SQL Database SKU recommendations (due November 2018).
    • Azure target recommendations , which identifies the best Azure target for your databases - Azure SQL Database, Azure SQL Database Managed Instance, or SQL Server on Virtual Machines (due January 2019).

This blog posting focuses primarily on DMA’s Azure SQL Database SKU recommendations feature, which allows you to identify the minimum recommended Azure SQL Database SKU based on performance counters collected from the computer(s) hosting your databases. This feature provides recommendations related to pricing tier, compute level, and max data size, as well as estimated cost per month. It also offers the ability to provision all your databases to Azure in bulk. Note that this functionality will currently be available only via the Command Line Interface (CLI).

To get Azure SQL Database SKU recommendations and to provision the associated databases to Azure, perform the following steps.

1. Collect performance counters from the computer(s) hosting your databases.

The first step in this process is to collect performance counters for your databases. You can do this 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 do not need to do this for each database individually. The performance counters collected from a computer can be used to recommend the best SKU for all databases hosted on the computer. Capture performance counters for at least 40 minutes to get a meaningful recommendation, though the longer the capture duration, the more accurate the recommendation. After you have collected the performance counters, you can use DMA to identify Azure SQL Database SKU recommendations.


2. Get Azure SQL DB SKU recommendations using DMA .

Use the performance counters output file from the previous step as input for DMA. DMA will provide you with recommendations for the Azure SQL Database pricing tier, the compute level, and the maximum data size for each of database on your computer. DMA will also provide you with the estimated monthly cost for each database. Please note that the recommended value is the minimum SKU required for your queries to run in Azure with a success rate similar to your on-premises databases.

 

3. Provision your databases to Azure using these recommendations.

With just a few clicks, you can use the recommendations from the previous step to provision target databases in Azure to which you can migrate your databases. You can also make changes to the recommendations by selecting the specific subscription and server that you want the databases provisioned to in Azure.

 


You can perform all the steps in this process on a single computer or you can perform it on multiple computers to determine SKU recommendations at scale. DMA makes it a simple and scalable experience by supporting all these steps through the CLI. Support for this feature via the DMA user interface is planned for delivery later this year.

For additional detail, see the article Identify the right Azure SQL Database SKU for your on-premises database.

Updated Mar 23, 2019
Version 5.0

3 Comments

Sort By
  • namkiwi's avatar
    namkiwi
    Copper Contributor
    Apr 13, 2021

    We are getting the same error - has anyone managed to come up with a solution?

     

    Thanks

  • prasanthSK's avatar
    prasanthSK
    Copper Contributor
    Feb 27, 2020

    Hello,

    I am unable to perform target sku recommendation using DMA CLI. When i execute the following the following code:

     


    .\DmaCmd.exe /Action=SkuRecommendation
    /SkuRecommendationInputDataFilePath="D:\counters.csv"
    /SkuRecommendationTsvOutputResultsFilePath="D:\prices.tsv"
    /SkuRecommendationJsonOutputResultsFilePath="D:\prices.json"
    /SkuRecommendationOutputResultsFilePath="D:\prices.html"
    /SkuRecommendationCurrencyCode=USD
    /SkuRecommendationOfferName=MS-AZR-0059P
    /SkuRecommendationRegionName=CentralUS
    /SkuRecommendationSubscriptionId=be866868xxxxxxxxxxxxxxxxxxxxx
    /AzureAuthenticationClientId=xxxxxxxxxxxxxxxxxxxfdf4a70bbf6
    /AzureAuthenticationTenantId=xxxxxxxxxxxxxxxxxxxxxx33daa4
    /AzureAuthenticationInteractiveAuthentication=true

     

     

    got the following error:

    DmaCmd.exe Information: 0 : 'Exception type: Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ActionExecutionException
    Message:
    An exception occurred while running the action 'AzureAuthentication'.
    HResult : 0x84C40001
    FacilityCode : 1220 (4c4)
    ErrorCode : 1 (0001)
    Data:
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ErrorFailureCategory = UnexpectedFailure
    ActionName = AzureAuthentication
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ActionName = AzureAuthentication
    Stack:
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute(NativeActivityContext context)
    at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
    at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation
    )
    Inner exception type: System.InvalidOperationException
    Message:
    No method of authentication possible with given context. Please specify the InteractiveAuthentication option, or provide a certificate to use with a registered A
    AD application.
    HResult : 0x80131509
    FacilityCode : 19 (013)
    ErrorCode : 5385 (1509)
    Data:
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ActionName = AzureAuthentication
    Stack:
    at Microsoft.SqlServer.Advisor.Workflows.Actions.Authentication.AzureAuthenticationAction.Execute()
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute(NativeActivityContext context)
    '
    DmaCmd.exe Information: 0 : Activity '7fd387c3-4155-48c2-96d2-b3f0b3404bab' has failed with an unhandled exception with name 'ActionExecutionException'
    DmaCmd.exe Information: 0 : Activity '7fd387c3-4155-48c2-96d2-b3f0b3404bab' completed in '94.9986' milliseconds.
    DmaCmd.exe Information: 0 : Activity '7fd387c3-4155-48c2-96d2-b3f0b3404bab' completed with outcome 'Failed'
    DmaCmd.exe Information: 0 : Error: Action "AzureAuthentication" threw an exception during execution.
    DmaCmd.exe Information: 0 : 'Exception type: Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ActionExecutionException
    Message:
    An exception occurred while running the action 'RunApplication'.
    HResult : 0x84C40001
    FacilityCode : 1220 (4c4)
    ErrorCode : 1 (0001)
    Data:
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ErrorFailureCategory = UnexpectedFailure
    ActionName = RunApplication
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ActionName = RunApplication
    Stack:
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute(NativeActivityContext context)
    at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
    at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation
    )
    Inner exception type: Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ActionExecutionException
    Message:
    An exception occurred while running the action 'AzureAuthentication'.
    HResult : 0x84C40001
    FacilityCode : 1220 (4c4)
    ErrorCode : 1 (0001)
    Data:
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ErrorFailureCategory = UnexpectedFailure
    ActionName = AzureAuthentication
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ActionName = RunApplication
    Stack:
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute(NativeActivityContext context)
    at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
    at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLoca
    tion)
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Workflow.Run()
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute(NativeActivityContext context)
    Inner exception type: System.InvalidOperationException
    Message:
    No method of authentication possible with given context. Please specify the InteractiveAuthentication option, or provide a certificate to use with a register
    ed AAD application.
    HResult : 0x80131509
    FacilityCode : 19 (013)
    ErrorCode : 5385 (1509)
    Data:
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ActionName = AzureAuthentication
    Stack:
    at Microsoft.SqlServer.Advisor.Workflows.Actions.Authentication.AzureAuthenticationAction.Execute()
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute(NativeActivityContext context)
    '
    DmaCmd.exe Information: 0 : The step 'ActivityError' in activity '7fd387c3-4155-48c2-96d2-b3f0b3404bab' reported an error but the activity was possibly already completed or
    was not started
    DmaCmd.exe Information: 0 : Activity '7fd387c3-4155-48c2-96d2-b3f0b3404bab' has failed with an unhandled exception with name 'ActionExecutionException'
    DmaCmd.exe Information: 0 : Error: Action "RunApplication" threw an exception during execution.
    DmaCmd.exe Information: 0 : 'Exception type: Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ActionExecutionException
    Message:
    An exception occurred while running the action 'RunApplication'.
    HResult : 0x84C40001
    FacilityCode : 1220 (4c4)
    ErrorCode : 1 (0001)
    Data:
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ErrorFailureCategory = UnexpectedFailure
    ActionName = RunApplication
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ActionName = RunApplication
    Stack:
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute(NativeActivityContext context)
    at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
    at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation
    )
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Workflow.Run()
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.InvokeEmbeddedWorkflowActivity.Execute(NativeActivityContext context)
    at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
    at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation
    )
    Inner exception type: Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ActionExecutionException
    Message:
    An exception occurred while running the action 'AzureAuthentication'.
    HResult : 0x84C40001
    FacilityCode : 1220 (4c4)
    ErrorCode : 1 (0001)
    Data:
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ErrorFailureCategory = UnexpectedFailure
    ActionName = AzureAuthentication
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ActionName = RunApplication
    Stack:
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute(NativeActivityContext context)
    at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
    at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLoca
    tion)
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Workflow.Run()
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute(NativeActivityContext context)
    Inner exception type: System.InvalidOperationException
    Message:
    No method of authentication possible with given context. Please specify the InteractiveAuthentication option, or provide a certificate to use with a register
    ed AAD application.
    HResult : 0x80131509
    FacilityCode : 19 (013)
    ErrorCode : 5385 (1509)
    Data:
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ActionName = AzureAuthentication
    Stack:
    at Microsoft.SqlServer.Advisor.Workflows.Actions.Authentication.AzureAuthenticationAction.Execute()
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute(NativeActivityContext context)
    '
    DmaCmd.exe Information: 0 : Activity 'a1b0ab1d-1ba2-461b-9b80-dbc14d7efa4b' has failed with an unhandled exception with name 'ActionExecutionException'
    DmaCmd.exe Information: 0 : Activity 'a1b0ab1d-1ba2-461b-9b80-dbc14d7efa4b' completed in '1173.9979' milliseconds.
    DmaCmd.exe Information: 0 : Activity 'a1b0ab1d-1ba2-461b-9b80-dbc14d7efa4b' completed with outcome 'Failed'
    DmaCmd.exe Information: 0 : Error: Action "BOOTSTRAP_CMD" threw an exception during execution.
    DmaCmd.exe Information: 0 : Unhandled exception reported, ErrorId '12913903849032198997', ExceptionName 'InvalidOperationException', Error '0x80131509', StackFrame 'Microsof
    t.SqlServer.Advisor.Workflows.Actions.Authentication.AzureAuthenticationAction.Execute', WatsonData 'NotSpecified', OuterExceptionName 'ActionExecutionException', OuterError
    Code '0x84C40001', OuterCallSite 'Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute', OuterWatsonData 'AzureAuthenticat
    ion'
    DmaCmd.exe Information: 0 : 'Exception type: Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ActionExecutionException
    Message:
    An exception occurred while running the action 'AzureAuthentication'.
    HResult : 0x84C40001
    FacilityCode : 1220 (4c4)
    ErrorCode : 1 (0001)
    Data:
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ErrorFailureCategory = UnexpectedFailure
    ActionName = AzureAuthentication
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ActionName = RunApplication
    DpesErrorReportedId = 12913903849032198997
    Stack:
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute(NativeActivityContext context)
    at System.Activities.NativeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
    at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation
    )
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Workflow.Run()
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute(NativeActivityContext context)
    Inner exception type: System.InvalidOperationException
    Message:
    No method of authentication possible with given context. Please specify the InteractiveAuthentication option, or provide a certificate to use with a registered A
    AD application.
    HResult : 0x80131509
    FacilityCode : 19 (013)
    ErrorCode : 5385 (1509)
    Data:
    Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Contracts.ActionName = AzureAuthentication
    Stack:
    at Microsoft.SqlServer.Advisor.Workflows.Actions.Authentication.AzureAuthenticationAction.Execute()
    at Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute(NativeActivityContext context)
    '
    DmaCmd.exe Information: 0 : A Windows Error Report for the exception based failure with id '12913903849032198997' has been created.
    DmaCmd.exe Information: 0 : Windows Error Report created for failure with id '12913903849032198997' with raw values of P0: DMAClient@5.0 ; P1: Microsoft.SqlServer.Advisor.Wo
    rkflows.Actions.Authentication.AzureAuthenticationAction.Execute ; P2: RunApplication ; P3: System.InvalidOperationException@19@5385 ; P4: NotSpecified ; P5: Microsoft.SqlSe
    rver.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute ; P6: Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.A
    ctionExecutionException@1220@1 ; P7: AzureAuthentication ; P8: None ; P9: None
    DmaCmd.exe Information: 0 : Windows Error Report created for failure with id '12913903849032198997' with hashed values of P0: DMAClient@5.0 ; P1: Microsoft.SqlServer.Advisor
    .Workflows.Actions.Authentication.AzureAuthenticationAction.Execute ; P2: RunApplication ; P3: System.InvalidOperationException@19@5385 ; P4: NotSpecified ; P5: Microsoft.Sq
    lServer.Fundamentals.OperationsInfrastructure.Workflow.Contracts.ComposableActivity.Execute ; P6: Microsoft.SqlServer.Fundamentals.OperationsInfrastructure.Workflow.Contract
    s.ActionExecutionException@1220@1 ; P7: AzureAuthentication ; P8: None ; P9: None
    DmaCmd.exe Information: 0 : Workflow host unhandled exception reported, ErrorId '12913903849032198997' with exception type 'InvalidOperationException'
    DmaCmd.exe Information: 0 : Result of submitting the error report '12913903849032198997' to WER: 'WerReportQueued'.
    DmaCmd.exe Information: 0 : The workflow host has stopped with exit code -2067529727 in assembly 'WorkflowHostProgram' and version '5.0.4591.1'
    /SkuRecommendationInputDataFilePath=D:\counters.csv : The term '/SkuRecommendationInputDataFilePath=D:\counters.csv' is not recognized as the name of a cmdlet, function,
    script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
    At line:2 char:1
    + /SkuRecommendationInputDataFilePath="D:\counters.csv"
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : ObjectNotFound: (/SkuRecommendat...D:\counters.csv:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

    /SkuRecommendationTsvOutputResultsFilePath=D:\prices.tsv : The term '/SkuRecommendationTsvOutputResultsFilePath=D:\prices.tsv' is not recognized as the name of a cmdlet,
    function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
    At line:3 char:1
    + /SkuRecommendationTsvOutputResultsFilePath="D:\prices.tsv"
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : ObjectNotFound: (/SkuRecommendat...h=D:\prices.tsv:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

    /SkuRecommendationJsonOutputResultsFilePath=D:\prices.json : The term '/SkuRecommendationJsonOutputResultsFilePath=D:\prices.json' is not recognized as the name of a
    cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
    At line:4 char:1
    + /SkuRecommendationJsonOutputResultsFilePath="D:\prices.json"
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : ObjectNotFound: (/SkuRecommendat...=D:\prices.json:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

    /SkuRecommendationOutputResultsFilePath=D:\prices.html : The term '/SkuRecommendationOutputResultsFilePath=D:\prices.html' is not recognized as the name of a cmdlet,
    function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
    At line:5 char:1
    + /SkuRecommendationOutputResultsFilePath="D:\prices.html"
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : ObjectNotFound: (/SkuRecommendat...=D:\prices.html:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

    /SkuRecommendationCurrencyCode=USD : The term '/SkuRecommendationCurrencyCode=USD' is not recognized as the name of a cmdlet, function, script file, or operable program.
    Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
    At line:6 char:1
    + /SkuRecommendationCurrencyCode=USD
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : ObjectNotFound: (/SkuRecommendationCurrencyCode=USD:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

    /SkuRecommendationOfferName=MS-AZR-0059P : The term '/SkuRecommendationOfferName=MS-AZR-0059P' is not recognized as the name of a cmdlet, function, script file, or
    operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
    At line:7 char:1
    + /SkuRecommendationOfferName=MS-AZR-0059P
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : ObjectNotFound: (/SkuRecommendationOfferName=MS-AZR-0059P:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

    /SkuRecommendationRegionName=CentralUS : The term '/SkuRecommendationRegionName=CentralUS' is not recognized as the name of a cmdlet, function, script file, or operable
    program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
    At line:8 char:1
    + /SkuRecommendationRegionName=CentralUS
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : ObjectNotFound: (/SkuRecommendationRegionName=CentralUS:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

    /SkuRecommendationSubscriptionId=be866868-a7e0-4273-9089-2f0021dfaa36 : The term '/SkuRecommendationSubscriptionId=be866868-a7e0-4273-9089-2f0021dfaa36' is not recognized
    as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try
    again.
    At line:9 char:1
    + /SkuRecommendationSubscriptionId=be866868-a7e0-4273-9089-2f0021dfaa36
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : ObjectNotFound: (/SkuRecommendat...89-2f0021dfaa36:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

    /AzureAuthenticationClientId=f6b11f9d-e951-4ec9-91ca-dfdf4a70bbf6 : The term '/AzureAuthenticationClientId=f6b11f9d-e951-4ec9-91ca-dfdf4a70bbf6' is not recognized as the
    name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
    At line:10 char:1
    + /AzureAuthenticationClientId=f6b11f9d-e951-4ec9-91ca-dfdf4a70bbf6
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : ObjectNotFound: (/AzureAuthentic...ca-dfdf4a70bbf6:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

    /AzureAuthenticationTenantId=0d20439b-e751-4a71-b68e-6b601a33daa4 : The term '/AzureAuthenticationTenantId=0d20439b-e751-4a71-b68e-6b601a33daa4' is not recognized as the
    name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
    At line:11 char:1
    + /AzureAuthenticationTenantId=0d20439b-e751-4a71-b68e-6b601a33daa4
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : ObjectNotFound: (/AzureAuthentic...8e-6b601a33daa4:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

    /AzureAuthenticationInteractiveAuthentication=true : The term '/AzureAuthenticationInteractiveAuthentication=true' is not recognized as the name of a cmdlet, function,
    script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
    At line:12 char:1
    + /AzureAuthenticationInteractiveAuthentication=true
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : ObjectNotFound: (/AzureAuthentic...entication=true:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException