You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include administrating a database named CK_DATA. CK_DATA is one of 15 databases located on a SQL Server 2005 computer named Certkiller -DB03. You have received several e-mail messages from users working on CK_DATA stating that they are experiencing long query execution times. As the administrator you want to reproduce and analyze this problem in a test environment that holds all copies of the production databases.
You need to record the workload for an entire day on Certkiller -DB03 for later execution on the test server. You need to make certain that all events are captured without skipping any, even though Certkiller -DB03 is under stress.
What should you do?
A.
You need to initiate the SQL Server Profiler on your computer prior to connecting to Certkiller -DBO3.
The Tuning template should then be used.
The trace should then be saved to a table on the test computer.
Thereafter you need to ensure that the Server processes trace data option is selected.
B.
You need to start SQL Server Profiler on your computer in order to connect to Certkiller -DB03.
The Replay template should then be used and the trace should be files on your computer.
You should then make sure that the Server processes trace data option is not chosen.
C.
You need initiate SQL Server Profiler on Certkiller -DB03 and connected locally.
You should then use the Tuning template.
A filter should be created for the DatabaseID column that is equal to the database ID of CK_DATA.
Thereafter you will be able to save the trace to a table on Certkiller -DB03.
D.
You need to initiate the SQL Server Profiler on the test computer prior to connection to Certkiller -DBO03.
You should then make use of the Replay template.
Then the trace can be saved to a file on the test computer.
It is then important that you make sure that the Server processes trace data option is chosen.
Explanation:
As the administrator you want to run the SQL Server Profiler from the test computer connected to the Certkiller -DB03 server.