%3CLINGO-SUB%20id%3D%22lingo-sub-1130871%22%20slang%3D%22en-US%22%3ELesson%20Learned%20%23121%3A%20The%20transaction%20log%20for%20database%20'tempdb'%20is%20full%20due%20to%20'ACTIVE_TRANSACTION'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1130871%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20been%20working%20on%20an%20issue%20that%20our%20customer%20reported%20this%20error%20message%20-%26nbsp%3BThe%20transaction%20log%20for%20database%20'tempdb'%20is%20full%20due%20to%20'ACTIVE_TRANSACTION'%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20is%20very%20important%20to%20know%20that%20this%20type%20of%20issue%20is%20based%20on%20an%20user%20query%20that%20is%20executing%20and%20we%20need%20to%20find%20out%20what%20is%20the%20query%20that%20is%20causing%20this.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20we%20reported%20in%20our%20previous%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-database-support-blog%2Flesson-learned-10-monitoring-tempdb-usage%2Fba-p%2F368825%22%20target%3D%22_self%22%3Earticle%3C%2FA%3E%20you%20could%20identify%20the%20query%20using%20this%20recomendation%2C%20also%2C%20please%2C%20review%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-database-support-blog%2Flesson-learned-7-monitoring-the-transaction-log-space-of-my%2Fba-p%2F368817%22%20target%3D%22_self%22%3Earticle%3C%2FA%3E%20about%20long%20transaction%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAdditionally%2C%20we%20would%20like%20to%20share%20with%20you%20other%20queries%20that%20could%20help%20you%20in%20this%20tracking%20process%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EUse%20dbcc%20opentran%20it%20will%20return%20any%20open%20transactions%20that%20would%20also%20cause%20the%20Tempdb%20to%20be%20full%2C%20for%20more%20information%20see%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Ft-sql%2Fdatabase-console-commands%2Fdbcc-opentran-transact-sql%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Ft-sql%2Fdatabase-console-commands%2Fdbcc-opentran-transact-sql%3Fview%3Dsql-server-ver15%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3ECreating%20an%20alert%20on%20the%20tempdb%20to%20send%20a%20notification%20when%20the%20Tempdb%20percentage%20exceed%20a%20specific%20the%20threshold%20to%20start%20the%20monitoring%20process%20by%20going%20through%20the%20scripts%20provided%20previously.%20For%20more%20details%20regarding%20the%20Alert%20see%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Falerts-metric%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Falerts-metric%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CBR%20%2F%3EEnjoy!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1130871%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20been%20working%20on%20an%20issue%20that%20our%20customer%20reported%20this%20error%20message%20-%26nbsp%3BThe%20transaction%20log%20for%20database%20'tempdb'%20is%20full%20due%20to%20'ACTIVE_TRANSACTION'%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20is%20very%20important%20to%20know%20that%20this%20type%20of%20issue%20is%20based%20on%20an%20user%20query%20that%20is%20executing%20and%20we%20need%20to%20find%20out%20what%20is%20the%20query%20that%20is%20causing%20this.%3C%2FP%3E%3C%2FLINGO-TEASER%3E

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!