May 21, 2013 at 12:47 am
Hello All,
I have a requirement where in i have to identify long running query under a particular login and the process should be a terminated or killed (if the query runs for more than 15 minutes) and communicated to the respective group along with the query.
How can i achieve this?
Your help would be appreciated.
May 21, 2013 at 1:48 am
Hi,
You can query sys.dm_exec_query_stats. There is much info about *_elapsed_time, *_logical_reads, *_logical_writes and etc.
Regards,
IgorMi
Igor Micev,My blog: www.igormicev.com
May 21, 2013 at 2:00 am
Check out this solution, might give you some ideas.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply