If page takes more time to open and transaction remain open in sql

If page takes more time to open and transaction remain open in sql

---

If you have website and your page is taking time to open then it may be possible that any transaction in sql(any query in sql) remains open (connection remains Open).So to check Open connections use this query :-

  USE TEMPDB   DBCC OPENTRAN

This will give you list of open transaction with its SPID.And you can see that open query using query given below :-

  DBCC INPUTBUFFER(SPID)

And then you can kill that open transaction using query :-

  KILL SPID;