DBA Unfiltered

  • Tempdb Transaction Log Full and Can’t Connect to SQL Server

    Problem Ran into an interesting one today. I’ve seen countless occurrences of tempdb filling up due to rogue queries that are poorly optimized. Today was the first time I’ve seen a full transaction log for tempdb result in me not being able to connect to the SQL instance at all. Normal troubleshooting and intervention would…

    TheUnfilteredDBA