When SQL Server 2016 RTM was released, there was the tool Stretch Database Advisor. This tool could be used to identify databases and tables that were candidates for the Stretch DB feature. It was a component of the SQL Server 2016 Upgrade Advisor, and by using it, you were also able to identify constraints and blocking issues that prevented the use of the feature.
However, this tool has been removed and replaced by the Microsoft Data Migration Assistant. But why I am mentioning this deprecated tool? The Stretch Database Advisor checked all tables in the database and creates a report showing the stretching capabilities of each table. I have used it to check which tables in the Microsoft sample SQL Server database AdventureWorks ...
