当Visual Studio运行时，SQL Server查询将被阻止 [英] When Visual Studio is running, SQL Server queries will block

问题描述

我突然遇到一个问题，即当Visual Studio 15.9.5同时运行时，我的开发机器上的本地SQL Server查询将无法运行。

我有一个dotnet核心我可以使用'dotnet run'运行PowerShell而没有问题的2.0 web项目。 但是，当我只在Visual Studio中打开相同的项目时，我在SSMS（或任何地方）中运行的任何查询都将阻止。 我甚至无法运行sp_who2
来查看发生了什么。

我没有在本周之前发生这种情况。 有什么想法可能会发生什么？ 我尝试禁用Application Insights，认为它可能与它有关，但它没有效果。

解决方案

嗨mikebridge，

欢迎来到MSDN论坛。

目前，我们需要逐一消除原因。

你能不能尝试通过sql cmd运行查询来测试它是否有效？如果使用sql cmd时一切正常。 VS可能与VS shell冲突。关于如何使用sql cmd，请参阅：
https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility ？view = sql-server-2017 。

此外，如果您可以分享更多关于此的详细信息，对我们来说更好。

期待您的回复。

Br

5月

I have suddenly encountered a problem where local SQL Server queries on my Development machine will not run while Visual Studio 15.9.5 is running simultaneously.

I have a dotnet core 2.0 web project which I can run with no problem from powershell using 'dotnet run'.  However, when I merely open that same project in Visual Studio, any query that I run in SSMS (or anywhere) will block.  I can't even run sp_who2 to see what's happening.

I haven't had this occur before this week.  Any ideas what might be occurring?  I tried disabling Application Insights, thinking that might have something do do with it, but it had no effect.

解决方案

Hi mikebridge,

Welcome to the MSDN forum.

For now, we need to eliminate the cause of reason one by one.

Could you try to run query by sql cmd to test if it works? If everything is ok when you using sql cmd. It possible that VS is conflicted with VS shell. About how to use sql cmd, see: https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-2017 .

Besides, it’s better for us if you can share more detail info about this.

Looking forwards your reply.

Br

May

这篇关于当Visual Studio运行时，SQL Server查询将被阻止的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！