SQL Server Performance

TSQL to get list of operations in active transaction of the current session

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jan 27, 2010.

  1. Anonymous New Member

    SQL Server has a wealth of Dynamic Management Views (DMVs) to get you health status of the platform. All the data will be extracted with a query, set of transactions and many more ways, in this case you had to be careful with transactions, because whenever so much data was flowing back and forth between the application server and the database server, too many things could go wrong. Here is the quick DMV that can get you list of operations in active transaction of the current session declare @xactid...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2010/01/27/6263.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=6263" width="1" height="1">

Share This Page