Lesson Learned #121: The transaction log for database ‘tempdb’ is full due to ‘ACTIVE_TRANSACTION’

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.

We have been working on an issue that our customer reported this error message - The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'

 

It is very important to know that this type of issue is based on an user query that is executing and we need to find out what is the query that is causing this.

 

As we reported in our previous article you could identify the query using this recomendation, also, please, review the article about long transaction

 

Additionally, we would like to share with you other queries that could help you in this tracking process:

 


Enjoy!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.