Blog Post

Core Infrastructure and Security Blog
3 MIN READ

Right Size/Recommend Azure SQL Managed Instance

wernerrall's avatar
wernerrall
Icon for Microsoft rankMicrosoft
Aug 22, 2022
Introduction When doing SQL Migrations we have some wonderful tools at Microsoft that will assist you with the migration from On-Premise to Azure. But What happens down the line when you need to de...
Updated Aug 22, 2022
Version 2.0
wernerrall
TF-sd's avatar
TF-sd
Copper Contributor
Sep 05, 2022

Will this work with a standard Azure SQL database (not managed instances?)

 

I've tried the method and am getting this error:

TC 2022-09-05 13:19:26, Server :
Collector 'Microsoft.SqlServer.Migration.SkuRecommendation.Collectors.PerfDataPointsCollector' failed to collect data.
UTC 2022-09-05 13:19:26, Server :
Error 208 - SQL connection failed to server instance '$sqlserver.database.windows.net'. Invalid object name 'sys.master_files'.Error code 208 was received with Severity 16..