Databases Reference
In-Depth Information
system drive and add the /3GB option as shown here, and then reboot
the machine.
multi (0)disk (0)rdisk (0)partition (2)\WINNT="????"
/3GB
In addition to turning on the /3GB option on a 32-bit machine, consider
using a machine with a large amount of memory (e.g. 8GB) whenever
you have SQL Server and Analysis Services installations on the same
machine and your UDMs have large dimensions (on the order of millions
of members). The additional memory on the 32-bit machine can be
accessed by SQL Server 2005 through Address Windowing Extensions
(AWE). Hence adding the additional memory helps ensure that both
servers have sufficient memory resources to provide good performance.
Another option is to use SQL Server and Analysis Services on 64-bit ma-
chines with larger memory.
If you do install SQL Server and Analysis Services on separate ma-
chines, they do not compete for resources, but you need to make sure
you have a good high-speed network connection between the servers,
such as gigabit Ethernet. Having good network connectivity helps reduce
the network transfer time for queries returning large volumes of data.
To stay legal, we recommend you check your licensing agreement for
installing SQL Server and Analysis Services on separate machines.
Optimizing a Relational Data Source
Analysis Services 2005 has improved fact table data reading by sending
the fact table scan query without joining dimension tables during MOLAP
partition processing. In Analysis Services 2000, you had to set the di-
mension key uniqueness to eliminate the joins between the fact table
and dimension table during the processing of the fact table. Analysis
Services 2005 sends a table scan query similar to the following to get
the fact data without the join and hence it is efficient as compared to
Analysis Services 2000 by default.
SELECT [dbo_WB_Fact].[BudgetExpenseAmount] AS
[dbo_WB_FactBudgetExpenseAmount0_0],
[dbo_WB_Fact].[EmployeeKey] AS
Search WWH ::
Custom Search