Database Reference
In-Depth Information
Figure 18-22.
Reviewing the imported trace data
If we make changes to the OLTP database, data warehouse, or SQL statements that improve the ETL
performance, we will be able to validate this improvement by setting up a SQL trace, performing the ETL
processing, importing the trace data into the metadata database, and comparing the aggregate average between
the two tables. If we can perform the same actions in less time with the same results, performance has been
improved!
eXerCISe 18-1. CreatING a SQL traCe
in this exercise, you create a trace file that stores information about the ETl processing of your Bi solution.
You then create a metadata database and import the trace information into a table. Afterward, you query the
traced data to find out the total duration.
Important:
As always, you will be practicing administrator-level tasks, so you need administrator-level
privileges. The easiest way to achieve this is to remember to right-click a menu item, select Run as
Administrator, and then answer Yes to access administrator-level privileges while running this program. in
Windows 7 and Vista, just logging in with an administrator account is not enough. For more information,
search the Web on the keywords “Windows 7 True Administrator and user Access Control (uAC).”
