无法停止使用实时查询执行查询统计信息。 [英] Query Executing with Live Query Statistics can not be stopped.

问题描述

Microsoft SQL Server 2016（CTP2.4） - 13.0.600.65（X64）  2015年9月20日01:45:59 版权所有（c）Microsoft Corporation 企业评估版（64位），适用于Windows 8.1 Pro 6.3< X64> （Build 9600：）（管理程序） 

Microsoft SQL Server 2016 (CTP2.4) - 13.0.600.65 (X64)   Sep 20 2015 01:45:59   Copyright (c) Microsoft Corporation  Enterprise Evaluation Edition (64-bit) on Windows 8.1 Pro 6.3 <X64> (Build 9600: ) (Hypervisor) 

我发现Live Query Statistics存在一个奇怪的问题（无法停止查询），执行7分钟后性质较慢的查询我试图阻止它从SSMS（Alt + Break），查询不停止，我必须杀死spid

I am seeing a odd issue with Live Query Statistics (Query can not be stopped), executed a query which is slow in nature after 7 mins i tried to stop it from SSMS (Alt+Break) , the query do not stop and i have to kill the spid

我有16到目前为止，系统上的GB内存和SQL Server使用了7 GB，当spid被杀死时，它给出了  无法解释的错误 

I have 16 GB of memory on the system and SQL Server has used 7 GB so far, when the spid was killed it gave an Inexplicable error 

Mohd Sufian www.sqlship.wordpress.com如果有帮助，请将帖子标记为已回复。

Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.

推荐答案

如果你从一个不同的查询窗口中杀死一个spid，你可以期待类似的东西，因为从SSMS的角度来看，连接被删除了意外地。

If you kill a spid from a different query window, you can expect something like, since from the point of view of SSMS, the connection was dropped unexpectedly.

更有趣的是你无法取消执行查询的原因。我担心我没有答案。我无法重现这种行为，但Alt + Break和红色按钮都适用于我。

The more interesting is why you were not able to cancel execution of the query. I'm afraid that I have no answer. I was not able to reproduce that behaviour, but both Alt+Break and the red button worked for me.

这篇关于无法停止使用实时查询执行查询统计信息。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！