You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network makes use of a SQL Server 2005 database. You have been informed by the CIO that a user reported that an order processing application stopped responding during a transaction. You investigate and detect that the user’s session is being blocked by an errant process. The user’s session is session ID 85. The session ID of the errant process is 101. You are required to solve this error as quick as possible in order for the user to carry on using the application without losing any work.
What should you do to accomplish this objective? (Choose all that apply)
A.
You need to restart the SQL Server (MSSQLSERVER) service in SQL Server Configuration Manager.
B.
You need to open a new query window in SQL Server Management Studio. Thereafter you can execute the KILL 85 statement.
C.
You need to open a new query window in SQL Server Management Studio in order to execute the KILL 101 statement.
D.
You need to open the Activity Monitor and then open the Process Info page. The session ID 85 needs to be right-clicked and Kill Process should be selected.
E.
You need to execute the NET STOP MSSQLSERVERNET START MSSQLSERVER statement at a Microsoft Windows command prompt.
F.
You need to open the Activity Monitor and then the Process Info page. Thereafter you should double-click session ID 101 to display the process details. You can then click on the Kill Process button.
Explanation:
As the administrator you want to KILL the errant process, not the one being blocked. You can kill the process either with a query or from the Process Info page in the SQL Server Management Studio. The Kill command can only be performed by a member of the sysadmin fixed server role.