Testing and Tuning BI Solutions - Pro SQL Server 2012 BI Solutions - page 757

6. using the save As dialog window, navigate to the folder

C:\_BISolutions\PublicationsIndustries . once there, create a new subfolder
called TraceFiles , as indicated in Figure 18-23 . This subfolder is where we place
the trace file.

7. in the “File name” textbox, enter ELTProcessingPerformance_Mar15_2012.trc as

the name of the trace file (Figure 18-23 ) .

8. Click save to close the save As dialog window. This will return you to the Trace

Properties dialog window.

9. in the Trace Properties dialog window, click the Run button at the bottom of the

screen to start the sQl trace.
Launching the etL process

now that the trace is running, we can launch the ETl process from Visual studio and capture trace data with
the following steps:

1. open Visual studio 2010. You can do so by clicking the start button and navigating

to All Programs ➤ Microsoft Visual studio 2010. Then right-click Microsoft Visual
studio 2010 to see an additional context menu. in this new menu, click the Run as
Administrator menu item. if the (uAC) message box appears asking, “do you want
the following program to make changes to this computer?” click Yes (or Continue
depending upon your operating system) to accept this request.

2. When Visual studio opens, open the Publications industries solution. You can do

so by using the File ➤ open-Project/solution menu item. A dialog window opens
allowing you to select your solution file.

3. navigate to the sln file C:\_BISolutions\PublicationsIndustries\

PublicationsIndustries.sln , select it, and then click the open button at the
bottom of the dialog window.

4. locate the dW pubs sales ETl project in solution Explorer and expand the treeview

to see the ssis Packages subfolder.

5. in the ssis Packages subfolder, right-click the ETLProcessForDWPubsSales.dtsx

integration services package and select Execute Package from the context menu.

6. let the package complete its execution. When the package completes, it should look

similar to Figure 18-17 .

7. stop the package using Visual studio's debug ➤ stop debugging menu item.

Stopping the trace

We have captured the data in a trace, but the trace continues to run until it has been stopped. We need to
stop the trace before we can import the trace data into the database.

1. navigate to sQl Profiler's window.

2. select File ➤ stop Trace from sQl Profiler's menu to stop the sQl trace.

3. Review the trace data. it should look similar to Figure 18-18 .