查询情况? [英] query situation?

问题描述

大家好.
我有一个查询，它需要2分钟才能执行(每个原因).
我不想讨论其性能.

我的问题是:如何找到有关查询现在正在执行并且尚未完全执行的情况.例如，我的C#代码如何在执行查询时每隔10秒查找多少条记录受到查询的影响或percent_complete? sql profiler是对我们说的吗?我使用了"sys.dm_exec_requests"和"percent_complete"列，但显示为0.我该怎么办?

Hi all.
I have a query that it need 2 minutes for executing (for each reason).
I don''t want to discuss about its performance.

My question is: How can I find situation about a query that it is executing now and it has not executed completely yet . for example How can my c# code find how many records are affected or percent_complete by my query every 10 seconds while that query is executing? Is sql profiler says that to us? I used "sys.dm_exec_requests" and "percent_complete" column, but it shows 0. what should I do?

推荐答案

这篇关于查询情况?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！