Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Transaction Log usage by Session

Author  Topic 

mitr
Starting Member

1 Post

Posted - 2014-10-31 : 05:25:12
Hi ALL,

I am a newbie to Sql Server, i am trying to find out the transaction log usage on a database by session.

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-10-31 : 13:20:15
Transaction log usage by session? Why? What are you trying to achieve?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Shanky
Yak Posting Veteran

84 Posts

Posted - 2014-11-07 : 11:54:16
Did you had chance to look at DMV http://msdn.microsoft.com/en-GB/library/ms186957.aspx columns database_transaction_log_bytes_used and database_transaction_log_record_count would interest you. Its not session scoped but per database scoped you can use begin tran and commit to get transaction log bytes used by particular session

Hope this helps

Regards
Shanky
SQL Server MVP
http://social.technet.microsoft.com/wiki/contents/articles/24253.list-of-articles-by-shanky.aspx
Go to Top of Page
   

- Advertisement -