Transaction monitoring query?

[bowwow]

Not sure if this is the best Forum, but does anyone know of a way in SQL 2005 (via a script) to monitor for long running transactions.

I can see that there is a Perfmon counter that covers this but for whatever reason it is not returning any values?

Any help much appreciated.

Kind Regards
B

 

[mrdenny]

You can look in sys.sysprocesses to see who has long running transactions.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com