Transaction Log Usage By Session ID

The following script will return the transaction log usage of each session (spid) on the SQL Server instance. This can be useful for determining long running queries, or the implications of killing a session as well as troubleshooting log reuse issues.Note that the log usage is m

5 Star
1,129 times
Add to favorites
E-mail Twitter Digg Facebook