Database Reference
In-Depth Information
Figure 18-20.
Reopening the trace file
Creating a Metadata Database
In addition to being able to reopen the trace file in SQL Profiler, you can quickly import the data into a SQL
Server table. The advantage of this is that it makes it much easier to compare and aggregate performance data
using SQL queries. You will need a database to store the trace table along with other trace tables you are using for
performance testing. And since you are most likely to perform many tests and performance trials, it makes sense
to create a metadata database to hold this type of data.
This metadata database is also a good place to store data about the objects that make up your solution. The
code in Listing 18-3 creates a database called PubsBISolutionsMetaData to contain information about testing and
performance and a catalog of solution objects. Figure
18-21
shows an example of a simple BI Metadata database
design. Starting with these core tables, you then add more tables with testing and performance data.
