ldf in simple mode grew

Question

The next .ldf grew to 50GB, and is eating all the disk… (it is in SIMPLE recovery model)

I wanted to be able to roughly answer these questions:

-what’s inside the .ldf? (can I say it is just temp tables?!) -which command or user caused this 50GB to fill up? -potential issues if I force to shrink the file to 10GB.

I do not want this information to blame anyone, but to educate ourselves on the usage.

Amazingly I get this result:

Answer 1

Check for uncommitted Transactions by running the below script:

SELECT 
er.session_id
,er.open_transaction_count
FROM sys.dm_exec_requests er

you can use sp_who2 to track down the user.

If you urgently need to free-up space in the Log file - without performing a shrink - take a log-backup.