I'm trying to decide whether this performance counter is worthwhile monitoring: \\SERVER\MSSQL:Transactions\Longest Transaction Running Time.
So during testing I tried to create some long running transactions but I can't seem to get this counter to read anything greater than zero.
But I can't find a transaction or query that will do it. As a starting point, I used the example query (an insert in a transaction) in the help for DBCC OPENTRAN with no luck.
Is there a query that affects this counter?