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.
Bạn đang xem 17. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P163 DOC