ProjectsV13 LocalDB实例的用途 [英] Purpose of ProjectsV13 LocalDB instance

问题描述

根据此答案，SQL Server数据工具使用私有的LocalDB实例ProjectsV13，您不应该这样做用于您自己的应用程序.相反，您应该使用MSSQLLocalDB或自己的私有实例.

According to this answer, SQL Server Data Tools uses a private LocalDB instance ProjectsV13, which you're not supposed to use for your own applications. Instead, you should use MSSQLLocalDB or your own private instance.

此文件记录在任何地方吗? SSDT将其私有实例用于什么? (我看不到我的任何东西.)

Is this documented anywhere? What does SSDT use its private instance for? (I don't see anything in mine.)

私有LocalDB实例是否基本上在扩展SQL Server的第二个副本?从表面上看，拥有专用于处理元数据的专用数据库引擎听起来相当耗费资源.这真的有多消耗资源吗?它对启动和使用Visual Studio有影响吗?如果是这样，并且如果真的不需要它，是否可以并且应该以其他方式将其关闭或合并实例?我的猜测不是；否则，SSDT不会使用私有实例，但是很高兴知道它是如何工作的.

Is a private LocalDB instance basically spinning up a second copy of SQL Server? On the surface, it sounds rather resource intensive to have a dedicated database engine just for tooling metadata. How resource intensive is this really? Does it have a perf impact on starting up and using Visual Studio? If so, and if it's not really needed, can and should you turn it off or consolidate instances in some other way? My guess is not; otherwise, SSDT wouldn't use a private instance, but it would be nice to know how this works under the hood.

推荐答案

主要原因是为了避免与MSSQLLocalDB上的任何生产"数据库发生冲突. SSDT为您打开的每个数据库项目创建一个新数据库.如果您的项目名为Adventureworks，则可能与由Web项目创建的或正在运行/调试的本地ASP.NET应用程序使用的Adventureworks数据库冲突.由于SSDT在后台自动执行此操作，因此认为存在冲突的风险过高.因此，使用了一个单独的实例.

The primary reason is to avoid conflicts with any "production" databases on MSSQLLocalDB. SSDT creates a new database for every database project you open. If your project is called Adventureworks, this might conflict with an Adventureworks database created by web projects or that are used by local ASP.NET applications you are running / debugging. Since SSDT does this automatically, in the background, it was felt that there was too high a risk of conflict. Hence, a separate instance is used.

LocalDB的资源使用率非常低，并且不会在启动时发生(它是异步的).它的设计目的是在不使用时降低转速，但是在运行VS并打开SQL Server Object Explorer时确实会产生影响(10兆MB)，因为这会连接到数据库.

The resource usage of LocalDB is pretty low and isn't incurred on startup (it's async). It's designed to spin down when not in use, but does have an impact (10s of MB) when running VS and having SQL Server Object Explorer open, since this connects to the DBs.

这篇关于ProjectsV13 LocalDB实例的用途的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！