Find Open Transactions on a SQL Server

Understanding DBCC OPENTRAN DBCC OPENTRAN is a SQL Server database console command (DBCC) that lets administrators to access information about the database's oldest current transaction, as well as the oldest…

Read Full
583 views 15:47 0 Comments

Find active transactions by duration

Recently frequently we faced blocking issues on our production server. The main reason that I understand, recently we merged a few SQL servers and migrated all databases to a single…

Read Full
229 views 07:31 0 Comments