What should you do to identify both the server process ID and the start time of the oldest active transaction
You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com are the administrating of a database named CK_Data that is situated on a SQL Server 2005 computer named Certkiller -DB03. As the administrator you receive a warning that the drive on which the CK_Data log file is situated is near capacity. The transaction log is backed up every five minutes. You notice that this is steadily growing. You suspect that an uncommitted transaction may be the reason and you want to investigate it. You want to identify both the server process ID and the start time of the oldest active transaction in CK_Data.
What should you do?