第一次连接数据库时，Visual Studio中的SQL Server对象资源管理器(SSDT)会构建整个数据库的架构模型.这是基于模型的数据库开发的概念，它提供了一些好处，例如无需修改实时数据库即可针对数据库验证脚本等.谈到Azure SQL DB，其中资源受数据库定价层限制，执行查询的性能提取数据库模型可能会有所不同.根据我们的性能测试，高于S1/S2的定价层提供的交互性与本地或本地SQL实例类似.

SQL Server Object Explorer (SSDT) in Visual Studio builds a schema model of entire database when you connect a database first time. This is a concept of model based database development which provides benefits such as validating scripts against database without needing to modify the live database etc. When it comes to Azure SQL DB where the resource is limited with your database's pricing tier, the performance of executing queries to fetch database model can vary. Based on our performance tests, pricing tiers above S1/S2 provides a similar interactivity as local or on-prem SQL instance.

更详细地讲，当前SSDT的机制是组合最少的查询数，以最大程度地减少与SQL Server/数据库的往返操作数，因此每个查询的执行时间更长.在执行查询时，它会影响SQL Server对象资源管理器的交互性.

More in details, current SSDT's mechanism is to composite minimum number of queries to minimize the number of round-trip operations with SQL server/database hence each query execution time is longer. It affects the interactivity of SQL Server Object Explorer while the query is being executed.

为增强功能，SSDT团队正在修订Azure SQLDB的设计，以提供更快的交互体验，同时保留基于模型的数据库开发的好处.

To enhance, SSDT team is revising the design for Azure SQLDB to provide a faster interaction experience while keeping the benefit of model based database development.

公开:我作为一名PM在SQL数据工具团队中工作