Quick Reference Guide

Dell Quickstart Data Warehouse Appliance 1000
Page 3
Internal Hard
Drives
• (22) 300GB 10K 2.5” SAS (18 Data, 4 Logs)
• (2) 600GB 10K 2.5” SAS (2 Hot Spares)
• (2) 600GB 10K 2.5” SAS (2 drives for OS) Rear Bay
Internal
Storage
Controller
PERC H710P Mini
Operating
System
Windows Server 2008 R2 SP1 Enterprise Edition
Database
Software
SQL Server 2012 Data Warehouse Appliance Edition
Server
Management
Dell Integrated Remote Access Controller (iDRAC7) Enterprise
Data
Integration
Dell Boomi (1
-
year
subscription
)
-Five standard connections. See more details at:
http://www.boomi.com/products/evaluate/supported_applications.
- Five test connections. Test connections are equivalent to standard
connections, but are used to integrate applications deployed in a test or
sandbox environment. The test connections may be used to set up a
redundant test, development, or QA environment.
- Molecule. A group of multiple nodes that distribute processing across one or
more physical machines. Used for integrations that receive or generate a high
volume of documents.
- Parallel Processing. Allows part of a process execution to be executed in
parallel to increase document throughput. Can help speed up slow or complex
steps by spreading memory across multiple computing processes.
- Advanced Workflow. The Quickstart Data Warehouse is delivered with
advanced features that are activated in AtomSphere for developing complex
integration processes. Includes the following components: Notify, Process
Call, Find Changes, Add to Cache, Cleanse, Flow Control, Business Rules, and
Catch Errors.
For SQL Server 2012 reference architectures, Microsoft recommends using 64GB to 128GB of memory
for one-socket configurations. This amount of memory improves the performance of large-scale queries
involving hash joins and sorting operations by offloading operations from the Tempdb to memory.
Using DIMM memory also plays a critical role in stack performance. The test configuration includes
96GB of 1333 MHz DIMMs. There are four 16GB DIMM in slots A1-A4 (white connectors) and four 8GB
DIMMs in slots A5-A8 (black connectors).