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

Figure 13-18
7. You learned in Chapter 12 that you can process the objects on an Analysis
Services instance using the dialogs or through scripts. The Process dialog
has the option to script the current settings to process the Internet_Sales
measure group. Click the Script to New Window in the process dialog
shown in Figure 13-17 . A processing script is now opened within SSMS
as shown below. Note that you could also use SQL Profiler to view the
process command received by the server.
<Batch ProcessAffectedObjects="true"
xmlns="http://schemas.microsoft.com/analysisservices/
2003/engine">
<Parallel MaxParallel="8">
<Process xmlns:xsd="http://www.w3.org/2001/
XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Object>
<DatabaseID>Adventure Works DW</DatabaseID>
<CubeID>Adventure Works DW</CubeID>
<MeasureGroupID>Fact Internet Sales
1</MeasureGroupID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
In the processing script you can see the option MaxParallel=8, which
instructs the Analysis Services instance to process a maximum of 8 ob-
jects in parallel.
Identify Resource Bottlenecks
Analysis Services processing and query performance requires well-configured
hardware resources for best results. Processing performance requires sufficient
memory, CPU speed, and good hard disk IO speed. These three play a significant