How to check the long running transaction ?

  • Interview Candidate
  • 2
  • 5577

Showing Answers 1 - 2 of 2 Answers

srihari

  • Jul 8th, 2007
 

select * from syslogshold

  Was this answer useful?  Yes

mikeob

  • Jun 17th, 2009
 

In addition to syslogshold one can look at master.sysprocess and the physical_io. If this is large (several hundred thousand) you are probably looking at a query doing a table scan. syslogshold tends to only store teh *longest*.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions