Transaction Log usage by Session

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/

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources