Performance Optimization - Professional SQL Server Analysis Services 2005 with MDX - page 680

served by Analysis Services need to be logged at a specific location. Analysis
Services provides a way to log the queries in a relational table with specific
parameters. Because this aggregation design technique is dependent on the
usage pattern, it is more likely that Analysis Services can create more useful
aggregations to increase performance of future queries. To create the user
based aggregation design, you first need to enable Analysis Services to log
the queries sent to the server. Follow these steps to enable query logging and
design aggregations based on a set of queries:
1. Launch SSMS and connect to Analysis Services.
2. Right-click the server and choose Properties. You will see the Ana-
lysis Server Properties window as shown in Figure 13-28 .
Figure 13-28
3. Set the "Log\QueryLog\QueryLogConnectionString" property so that
it has a connection string pointing to a relational database where
queries can be logged. To do so, click the ellipsis ( … ) to launch the
connection string dialog.
4. You will see the connection manager dialog as shown in Figure
13-29 , which you have used to specify data sources. Specify the