You have run a server side trace that created 45 trace files. You want to load the trace files on your workstation in a database table called PerfData for further analysis. ou need to load three…

The correct answer is B. SELECT * INTO PerfData. sys.fn_trace_gettable returns the content of one or more trace files in tabular form. fn_trace_gettable ( 'filename' , number_files ) Specifies the initial trace file to be read. filename is nvarchar(256), with no default. Specifies the number of rollover files to be read. This…

Troubleshoot and Optimize Databases

Question

You have run a server side trace that created 45 trace files. You want to load the trace files on your workstation in a database table called PerfData for further analysis. ou need to load three files starting at c:\my_trace_38.trc. Which Transact-SQL statement should you use?

Options

ASELECT * INTO PerfData
BSELECT * INTO PerfData
CSELECT * INTO PerfData
DSELECT * INTO PerfData

How the community answered

(22 responses)

A
5% (1)
B
77% (17)
C
14% (3)
D
5% (1)

Explanation

sys.fn_trace_gettable returns the content of one or more trace files in tabular form. fn_trace_gettable ( 'filename' , number_files ) Specifies the initial trace file to be read. filename is nvarchar(256), with no default. Specifies the number of rollover files to be read. This number includes the initial file specified in number_files is an int. If number_files is specified as default, fn_trace_gettable reads all rollover files until it reaches the end of the trace.

Topics

#trace files#fn_trace_gettable#SQL Server Profiler#performance data loading

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice