Hi all. I am a c# programmer. 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?
View Complete Post