Azure Data Studio - SQL Migration extension

Mark Gordon 901 Reputation points
2023-01-31T16:42:43.09+00:00

Fellow DBA,

We are using the new Azure Data Studio with the SQL Migration Extension plug in.

When you select a number of databases on an instance to evaluate, then you setup collecting performance measures, is it looking at the measures ONLY for those selected db's or is looking at the entire instance regardless of dbs.?

Thanks,

MG

Azure SQL Database
{count} votes

Accepted answer
  1. GeethaThatipatri-MSFT 26,462 Reputation points Microsoft Employee
    2023-02-01T17:26:15.6966667+00:00

    Hi, @Mark Gordon Thanks for providing additional information, When collecting data it collects for the whole instance and all databases at once but when you run the recommendation, it only recommends for whatever dbs were selected on the original assessment page, the only thing that doesn't take into account specific dbs is the data collection process, but once the data has been collected, you can run recommendation for any subset of databases you want and the recommendation will respect it, you just don't need to recollect data every time is the point.

    I hope this information helps, please let me know if you have any additional questions.

    Regards

    Geetha


0 additional answers

Sort by: Most helpful