There are quite a few solutions on the internet dealing with runaway transaction log files.During some sql server performance troubleshooting yesterday, I was reminded of how important analysing large transactions and the impact on transaction logs. The sys.dm_tran_database_transactions DMV returns transaction information at the database level. Creating a JOIN with the sys.dm_exec_requests DMV (which returns details of sql requests executing) , creates a resultset with granular information on transaction log usage per request. What’s the point of this information? What sort of problems can be solved using this information? Here are some examples : 1)Identifying very large deletes generating large... Read more →