Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Transaction details Expand / Collapse
Author
Message
Posted Friday, August 6, 2010 12:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 3:04 AM
Points: 274, Visits: 1,468
Hi,
Is there any way to find out details of particular transaction. We can check current transaction ID in SQL 2005, but can we check the whole details of transaction ? Like who is the owner of transaction, database, complete T-SQL of that transaction without using tracing or auditing ?

Thanks in advance:)
Post #964864
Posted Friday, August 6, 2010 2:38 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 2:46 AM
Points: 999, Visits: 13,480
beejug1983 (8/6/2010)
Hi,
Is there any way to find out details of particular transaction. We can check current transaction ID in SQL 2005, but can we check the whole details of transaction ? Like who is the owner of transaction, database, complete T-SQL of that transaction without using tracing or auditing ?

Thanks in advance:)


you can use sys.sysprocesses to get a lot of that information.

you can use dbcc inputbuffer to get the t-sql statement. There are also various DMV's you can use to get similar information
Post #964901
Posted Friday, August 6, 2010 4:59 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
You can use some of the 3rd party tool to indentify the transaction details.

HTH


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #965003
Posted Friday, August 6, 2010 6:35 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 7:49 AM
Points: 15,713, Visits: 28,120
Dynamic Management Views (DMV) to the rescue!

Look up in BOL sys.dm_tran_*. You'll find more information than you can shake a stick at. You can combine this with other DMVs like sys.dm_exec_requests or sys.dm_exec_sql_text or sys.dm_exec_query_plan, to put together just about any information you might want about ongoing transactions.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #965073
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse