问题描述
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.
推荐答案
更有趣的是你无法取消执行查询的原因。我担心我没有答案。我无法重现这种行为，但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.
这篇关于无法停止使用实时查询执行查询统计信息。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！