CODEWITHSUNDEEP
sql-servertransaction-logtempdb
anu
anu

Reputation: 21

Tempdb transaction log full

Unable to connect to SQL Server because:

'tempdb transaction log was full due to active transaction'.

There was no way to login to SQL Server to troubleshoot. only option was to restart SQL Server.

I want to know ow to avoid this issue in future. The log file and data files were limited to max size. But is there a way I can be notified before tempdb log file reaches maximum? Is there a way i can get alert or monitor tempdb space usage when it reaches 85% full get notified. this issue cause a big impact as well. so any advise how it can avoided in future will be very helpful.

Upvotes: 1

Views: 545

Answers (0)

Related Questions