Database Reference
In-Depth Information
An Example Scenario
Let's take a moment to examine how you could capture trace information on ETL processing. The first step would
be to create a new trace. In Figure 18-17 , we named the trace ETLProcessingPerformance , used the template
called Tuning, and saved the trace data to a new file called C:\_BISolutions\PublicationsIndustries\
TraceFiles\ELTProcessingPerformance_Mar15_2012.trc . After configuring these settings, clicking Run at the
bottom of the Trace Properties dialog window begins the trace.
Figure 18-17. Creating a new trace to benchmark ETL processing performance
saving the trace to a file is a simple and efficient way to record the stored trace data. This is very important
when you are trying to create a benchmark for relative performance tuning. With it you can compare earlier trace
data to current trace data, noting whether the performance has been improved by recent changes to the database.
Tip
With the trace running, we need to start the ETL process and record its performance. So, we open Visual
Studio and execute the SSIS package we created for the Publication Industries BI solution. It takes a few seconds
to run; as it does, each of the containers and tasks will indicate its success or failure. In Figure 18-18 , our SSIS
package has completed all tasks successfully, as indicated by the check marks. (The check marks will be green on
your screen.)
 
 
 
Search WWH ::




Custom Search