SQL Server sys.dm_tran_active_transactions long running …
Jul 19, 2019 · I see the same thing on my 2016 instance - exactly 6 worktable transactions, that started just a few seconds after the server started up. If I join to …
sql server - How to identify which query is filling up the tempdb ...
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.
sql server - Finding reason for transaction log 'tempdb' full due to ...
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 …
Unable to shrink transaction log file in SQL Server
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 …
sql server - Is it a bad practice to always create a transaction ...
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 …
sql server - Why Does the Transaction Log Keep Growing or Run …
Dec 5, 2012 · In this case, when SQL Server reaches the point where it would be safe to truncate the log file under the simple recovery model, it will not do that. Instead, it lets the log file …
How can I enable distributed transactions for a linked server?
I have a SQL Server 2012 instance with a linked server pointing to a db2 database on an IBM Iseries system using the System i Access ODBC Driver. I'm trying to enable distributed …
sql server - How can I reduce the size of a huge LDF file?
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 …
sql server - Transaction in a stored procedure - Database ...
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?
sql server - How best to resolve excessive Transaction Log size ...
Nov 20, 2022 · 2 I understand excessive Transaction Log growth is a very common issue, and has been asked and answered many times. (Why Does the Transaction Log Keep Growing or …