You have a SQL Server 2005 computer named SQL1. Users report that the time required to run their queries on SQL1 is steadily increasing. You want to investigate this issue by using SQL Server Profiler to trace all user queries. You need to decide on which computer to run SQL Server Profiler, and where to store the trace. You must minimize the impact of this operation on SQL1 performance.
What should you do?
A.
Run SQL Server Profiler from the console of SQL1. Store the trace in a table on SQL1.
B.
Run SQL Server Profiler over a Remote Desktop connection to SQL1. Store the trace in a file on a separate computer.
C.
Run SQL Server Profiler on a separate computer that is connected to SQL1. Store the trace in a table on SQL1.
D.
Run SQL Server Profiler on a separate computer that is connected to SQL1. Store the trace in a file on the computer that is running SQL Server Profiler.