WHAT’S THE BEST METHOD TO RUN A SQL TRACE WITH MINIMUM OVERHEAD ON...

17. What’s the best method to run a SQL Trace with minimum overhead on the

server being traced?

A. Run SQL Profiler from your desktop.

B. Run SQL Profiler from the server.

C. Run a server-side trace to a database on the server.

D. Run a server-side trace to a file on a fast local disk.

The correct answer is D. The best method to minimize the overhead of

running a SQL trace is to output the trace to a file on a fast local disk.

Once the trace is stopped, the file can be copied to a workstation or another

server for analysis. Answers A, B, and C are all valid options, but none are

the best.