Database Reference
In-Depth Information
Importing the trace Data
With the sQl trace stopped, import the trace into the database.
1.
open sQl Management studio. Remember that you will need to right-click its
menu item to see an additional context menu allowing you to 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.
once sQl Management studio opens, use the File ➤ open ➤ File menu option to
access the open File dialog window.
3.
navigate to the
C:\_BookFiles\Chapter18Files\ListingCode
folder and select
the
Listing 18-1. Creating a Metadata database.sql
file to open it.
4.
Review the code inside this file and execute it to create the metadata database.
5.
navigate to the
C:\_BookFiles\Chapter18Files\ListingCode
folder and select the
Listing 18-2. Importing trace data from a trace file.sql
file to open it.
6.
Review the code inside this file and execute it to import the data from the trace file
into a new table.
examining trace Data
now that the data has been imported into a table, you can use a sQl query to examine the data.
1.
navigate to the
C:\_BookFiles\Chapter18Files\ListingCode
folder and select
the
Listing 18-3. Getting performance information from the trace data.
sql
file to open it.
2.
Review the code inside this file and execute it to access the trace data.
3.
Review the information that is available to you in this table.
in this exercise, you practiced creating a sQl Profiler trace and reviewed the information within it. This
strategy can be used to trace other aspects of your Bi solution as well, such as the ssAs processing and the
ssRs report queries.
Moving On
Once you have performed all your tests and completed your initial tuning, you are almost ready to let your clients
begin using your BI solution. Next we will get it formally approved and then release it! But for now, Figure
18-24
gives an overview of where we are in the BI solution life cycle.
