CODEWITHSUNDEEP
sqlsql-server
EetSandhu
EetSandhu

Reputation: 49

the transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION

I'm running same query in two different windows of the same server. the only difference is : the query that is throwing above error has got 'index' on the temporary tables.

The query w/o index on temporary tables is working fine. Please explain how could index be a reason for this error?

Upvotes: 1

Views: 5755

Answers (1)

Paolo
Paolo

Reputation: 121

This depends from your query. SQL-Server has to maintain indexes during data changes. This can drives you in different time-waith events.

Try this: check on your two different SQL Server instances what's heppening exactly to your running session during query executon. You can do this monitoring wait events creating a monitor sessions for a single SPID.

This is my complete procedure to this: http://zaboilab.com/sql-server-toolbox/monitoring-wait-events-of-a-single-session-or-query

Upvotes: 1

Related Questions