Network
In Recovery... | Script: open transactions with text and plans
sqlskills.com/BLOGS/PAUL/post/Script-open-transactions-with-text-and-plans.aspx
–
view page
–
cached page
Home | Subscribe | About | Contact | Twitter | consulting | training | server health audits | Site Admin
All posts about this link
All posts about this link
@chadchurchwell Only if the transactions are still running - see my blog post: http://t.co/90UGB7t3 #sqlhelp
@SQLBob #sqlhelp Look at output from sys.dm_tran_database_transactions - see http://tinyurl.com/5vn4kdc
@JustAGuy0479 #sqlhelp Have a look at this script - does it say the same for tempdb
@SQLBob #sqlhelp Can you do it inside a transaction and then use script on http://tinyurl.com/5vn4kdc to see whether logged amount same?
Script: open transactions with text and plans:
(Edited 2/27/10 to add database name to the output)
Here's a li..
Very useful script for finding open transactions by @PaulRandal: http://bit.ly/cktMaX
RT: [Blog] Script: open transactions with text, plans, log usage http://bit.ly/bMcXyt #sql #sqlserver
Found: Script: open transactions with text and plans http://bit.ly/apRk54
[Blog] Script: open transactions with text and plans http://bit.ly/bMcXyt #sql #sqlserver