Jun 25, 2012 · I would like to know how to identify the exact query or stored proc which is actually filling up the transactional log of TEMPDB database.

Jul 19, 2019 · SQL Server sys.dm_tran_active_transactions long running transaction worktable Ask Question Asked 6 years, 3 months ago Modified 6 years, 2 months ago

Jan 4, 2021 · Our application stopped working suddenly due to The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'.. Now, it start working again. But how can I …

122 Is it a bad practice to always create a transaction? For example, it is a good practice to create a transaction for nothing but one simple SELECT? What is the cost of creating a transaction …

Mar 21, 2017 · 10 Why do I get The transaction log for database 'X' is full due to 'ACTIVE_TRANSACTION' on a database with Simple recovery model and auto-growing log …

Mar 9, 2023 · Both the software and the SQL Server is setup on the same server which we have in our office. We are running out of disk space also it is taking a lot of time for us to FTP the …

When I try to nest this transaction in a stored procedure I run into lots of syntax errors. How can I encapsulate the following code so it can be easily called?

Mar 29, 2019 · I am aware of the Performance Counters for SQL Server:Databases - Transactions/Sec AND Batches/Sec. Do I simply convert these transactions per second data …

Dec 31, 2016 · I moved to a new company recently wherein they have 2 databases in a SQL server of size 20-25 GB. I'm unable to shrink the log file of the databases. Transaction log …

So, it’s recommended before goes live you should prepare LOG_BACKUP Maintenance Plan to back up the log file frequently to avoid the shrink operation on Production. For more details …