Home Forums SQL Server 2008 SQL Server 2008 Administration How to identify which transaction is generating "Longest Transaction Running Time" alert RE: How to identify which transaction is generating "Longest Transaction Running Time" alert

  • Counters by themselves are useless.

    You need to compare them to a baseline.

    This is probably closer to what you need : http://www.red-gate.com/products/dba/sql-monitor