Domain.com has employed you as a database administrator. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com are the administrating of the SQL Server 2005 computer named Certkiller -DB02.
You have received several reports from clients stating that the time required to run their queries on Certkiller -DB02 is gradually increasing. You have been informed by the CIO to decide on which computer to run SQL Server Profiler as well as where to store the trace.
You are required to investigate this matter by using the SQL Server Profiler to trace all client queries. You need to minimize the impact of this operation on Certkiller -DB02 performance.
What should you do?
A.
You should ensure that the SQL Server Profiler is run over a Remote Desktop connection to Certkiller -DB02.
Thereafter you will be able to store the trace in a file on a separate computer.
B.
You should run SQL Server Profiler on a separate computer that is connected to Certkiller -DB02.
Thereafter the trace can be stored in a table on Certkiller -DB02.
C.
You should run the SQL Server Profiler on a separate computer.
This computer needs to be connected to Certkiller -DB02.
Thereafter you can store the trace in a file on the computer that is running SQL Server Profiler.
D.
You should ensure that the SQL Server Profiler is run from the console of Certkiller -DB02.
The trace can then be stored in a table on Certkiller -DB02.
Explanation:
To reduce the impact on Certkiller -DB02 when running the SQL Server Profiler it is important that you run this on a separate computer connected to Certkiller -DB02 (and a remote desktop session is NOT a separate computer). Thereafter you can store the trace on the computer running the SQL Server Profiler.