Viewing 9 posts - 1 through 9 (of 9 total)
Resolved after optimizing sp code.
Thank you!
May 21, 2017 at 12:42 am
May 20, 2017 at 9:41 pm
May 18, 2017 at 9:21 am
May 18, 2017 at 8:45 am
May 18, 2017 at 8:42 am
Link to github seems to be broken.
But the one you posted in this thread is Ok.
Thanks!
March 1, 2017 at 10:14 pm
What do you mean "get 3 envelopes"?
February 11, 2015 at 9:59 am
--Current queries
SELECT
r.session_id,
s.TEXT,
r.[status],
r.blocking_session_id,
r.cpu_time,
r.total_elapsed_time
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s
Find blocking_session_id or heavy one and then
kill #
February 11, 2015 at 7:44 am
Viewing 9 posts - 1 through 9 (of 9 total)