find transaction that generated 4 Go in journal file

We are using SQL Server with logshipping.

I noticed in the last two days the presence of 2 bigs journal files
(about 2Go each, transfered from primary to secondary ).

I want to know if there is a way to see what was the operation that lead to have this to big 2 log files
(sql statement or transaction... : with Oracle for instance, if we have chance, we can find this kind of info in
a dynamic views by the name of : v$sqlarea...)...

Thanks in advanceI don't think you can do this without a third party tool, such as the Lumigent (http://www.lumigent.com/) log explorer. I'm not even sure what that can do with log shipping, but it is where I'd start.

-PatP

Find out what is written into transaction log

Hi,
My transaction log grows around 5 Gb an hour. I'm trying to find out what is
being written there and running SQL profiler. I can find very few
transactions with Writes other then 0. How can I find out what is being
written into transaction log in such huge volumes?
Have a look at getting a log viewer tool eg Lumigent's LogExplorer or
Redgate's LogRescue.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Find out what is written into transaction log

Hi,
My transaction log grows around 5 Gb an hour. I'm trying to find out what is
being written there and running SQL profiler. I can find very few
transactions with Writes other then 0. How can I find out what is being
written into transaction log in such huge volumes?Have a look at getting a log viewer tool eg Lumigent's LogExplorer or
Redgate's LogRescue.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Find out what is written into transaction log

Hi,
My transaction log grows around 5 Gb an hour. I'm trying to find out what is
being written there and running SQL profiler. I can find very few
transactions with Writes other then 0. How can I find out what is being
written into transaction log in such huge volumes?Have a look at getting a log viewer tool eg Lumigent's LogExplorer or
Redgate's LogRescue.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Find open transactions

Is there an easy way (SQL Query or enterprise manager) to see if there is an open transaction pending?

yes, you can look into Management Activity monitor.
I do not know why you need this but remember that transaction is active as long as connection is active so if you look for not finalized transaction which were done in dropped connection it probably will not work.
I am not 100% sure about this but I found it somewhere.

Thanks

|||

I missed it when I looked before. FYI, I needed the information because I was debugging a long script that for some reason wasn't executing the statements after a certain line. I thought it might have been due to a transaction not being closed. But it was bad data preventing a unique index from being created.

Thanks for the answer.