|
| | | 
StrataFrame User
 
Group: StrataFrame Users
Last Login: 07/09/2008 2:20:16 PM
Posts: 436, Visits: 944 |
| I'm using transactions in .NET and i was wondering if there was a way to see when one was opened or started. Is there a SQL Server program or a .NET utility to watch the server and see when a transaction is started, etc.
Just curious. |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 1:09:23 PM
Posts: 2,686, Visits: 1,888 |
| I think there is a performance counter that you can hook into SQL Server to watch the number of transactions... when it increments, you'll know a new one was started. But other than that, I don't think there is an event or anything within SQL Server that will tell you when a new transaction is started.
www.bungie.net |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 1:09:23 PM
Posts: 2,686, Visits: 1,888 |
| Just do a google or msdn2.microsoft.com search for "performance counter sql server transactions" (without the quotes) and I'm sure you'll find something.
www.bungie.net |
| |
|
|