Dell PowerEdge R510 - Manual (Page 14)

Dell R510 Reference Configuration for Microsoft SQL Server® 2008 R2 Fast Track Data Warehouse
Page 12
Calculating BCR
BCR is calculated in terms of total read bandwidth from the storage hard drives and not from the
buffered cache as in the MCR calculation. This is measured by running a set of standard queries specific
to the data warehouse workload. The queries range from I/O intensive to CPU and memory intensive,
and provide a reference to compare various configurations.
For the validated Fast Track configuration, the aggregate BCR was 1021 MB/s.
During the evaluation cycle, the system configuration was analyzed for multiple query variants (simple,
average and complex) with multiple sessions and different degrees of parallelism (MAXDOP) options to
arrive at the optimal configuration. The evaluation results at each step were validated and verified
jointly by Dell and Microsoft. A summary of the Fast Track results are offered in the Appendix.
Populating Your Data Warehouse
Integrating multiple data sources efficiently, easily, and accurately is essential to any enterprise data
warehouse. Dell helps make this possible with the Dell Boomi Integration Cloud. As the recipient of the
CODiE award for best cloud integration platform for the past three years, Dell Boomi is widely
recognized as the industry’s leading application and data integration provider.
By building our data and application integration platform in the cloud, we’ve created a fundamentally
different approach. Dell Boomi helps to reduce TCO as compared to traditional integration tools or
custom coding. Because Dell Boomi is delivered in the cloud, there is never any software to maintain,
and minimal IT resources are required for ongoing management. In addition, our library of pre-built
connectors eliminates the need to build and maintain custom code. Dell Boomi also strengthens data
security because data never passes through the Boomi platform; data is only processed through the
Atom runtime engine located in the cloud or in the customer’s own infrastructure, so the customer can
select where the data flows.
Dell Boomi’s intuitive visual design interface makes it easy to begin creating integration processes
immediately. Using familiar point-and-click drag-and-drop techniques, users can build very simple to
very sophisticated integrations with exceptional speed. As the Dell Boomi community expands, so does
the number of connectors and process maps, and many are already built and ready for use, easing the
job of connecting new applications. Training costs are low due to the platform’s simplicity and ease of
use.