Identify Oldest Active Transaction with DBCC OPENTRAN

The DBCC OPENTRAN command gives you the information you need by displaying information about the oldest active transaction and the oldest distributed and nondistributed replicated transactions within the specified database. You can run this against any database and it gives very useful information very quickly. /*Select the database where you want to check open transactions*/ use History […]

Read more