PrepAway - Latest Free Exam Questions & Answers

Tag: process id in sql server

What should you do to identify both the server process ID and the start time of the oldest active transaction

You manage a database named DB1, which is located on a SQL Server 2005 computer.
You receive a warning that the drive on which the DB1 log file is located is near capacity.
Although the transaction log is backed up every five minutes, you observe that it is steadily growing. You think that an uncommitted transaction might be the cause and you want to investigate.
You need to identify both the server process ID and the start time of the oldest active transaction in DB1. What should you do?