You are the administrator of your company network. Now you’re in charge of a SQL Server 2008 instance.
A user called Jack is running a query and he reports that he is waiting for it to complete. So you have to identify whether the query is blocked. So which tool should you use to achieve this?

A.
You should use the Windows System Monitor tool

B.
You should use the Database Engine Tuning Advisor tool

C.
You should use the Job Activity Monitor tool in Microsoft SQL Server Management Studio

D.
You should use the Activity Monitor tool in Microsoft SQL Server Management Studio