本文介绍了无法停止使用实时查询执行查询统计信息。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

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.


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

08-23 07:07