software. Because of its price leadership, midmarket customers can now afford to ... software and hardware integration.
Dell Quickstart Data Warehouse Appliance Deploying a new data warehouse
the hardware or installing,
software and hardware integration.
or data mart, from planning to
balancing, and optimizing the
The appliance includes two hot
testing, can be complex and costly
software. Because of its price
spare data disk drives, which can
for departmental deployments and
leadership, midmarket customers
be used in case of data disk failure,
midmarket companies. A pre-
can now afford to deploy a
and the OS/System drive is
architected, preconfigured, highly
complete data warehouse solution
mirrored to withstand the loss of a
tuned solution can minimize the
even with limited budget, IT skills
system drive.
risks involved, simplify deployment
and resources. The competitive
without requiring high levels of
price of Dell Quickstart Data
expertise, and save time and costs
Warehouse Appliance includes
during planning, design,
everything you need to get up and
installation and management.
running quickly; as well as
The Dell Quickstart Data Warehouse Appliance with SQL
comprehensive support services for the hardware and software.
The system is based on the new Dell 12th generation PowerEdge server and includes the Windows operating system, an OEM version of SQL Server 2012 called the data warehouse appliance license (which is a subset of the Enterprise
Server 2012 is built on the proven
The solution is focused on
edition encapsulating all of the
Microsoft SQL Server 2012 Fast
delivering the core data warehouse
SQL Server 2012 data warehousing
Track Data Warehouse Reference
capabilities through innovative
features), and storage to support
Architecture. Customers are
new technologies that provide a
up to 5TB of user data, based on a
delivered a pre-built solution that
high level of performance,
typical compression ratio of 2-3x.
addresses their data warehouse
efficiency, and ease of use. It also
project requirements without
provides capabilities to ensure
needing to worry about building
high availability through the
In partnership with
Also included with the appliance is
partnership by Dell and
Reducing the input/output
Dell Boomi to enable easy
Microsoft
bottleneck that so often limits data
integration of data from any source: on-premises, SaaS, or cloud. Customers not only receive the hardware and software, but also receive a complete services and support offering to ensure ongoing success. This includes a hands-on boot camp on data warehousing, the appliance setup, and training services to minimize implementation risks and get
High performance through optimized hardware and software Reduced time to solve technical issues through Dell's global support service
Dell Hardware, Software & The Dell Quickstart Data Warehouse Appliance is a solution that includes:
quarterly data warehouse system
High performance 12th
performance assessments,
generation PowerEdge
including data warehouse designs,
hardware. SQL Server 2012 data
setting checks to ensure
warehouse appliance license
continuing success of the
from Microsoft.
implementation.
Key Benefits A complete and integrated solution that includes hardware + software + services + support
1 year subscription to Dell Boomi for data integration. Appliance support. Built-in startup, training, and quarterly healthcheck services.
CPU
Memory Hard disk drives
Description Dell 12th generation server ® Quad Core Intel ® Xeon E5-2643 CPU @3.3Ghz 96GB 22 * 300GB internal SAS 4 * 600GB
Two of the hard disk drives are dedicated to running the Windows Server 2008 R2 operating system and two are hot spare data disks. The other 22 support the database management system and also provide storage for up to 5TB of compressed user data. The appliance models include all the software you need to
preinstalled with Windows Server 2008 R2 and the latest Microsoft Figure 1: Dell Quickstart Data Warehouse Appliance
SQL Server 2012 data warehouse appliance license, enabling you to use the newest data warehouse
and automated setup
configurations, designed in
Hardware component Server
user data. The appliance is
appliance packaging
Reduced risk through pretested
when they need it.
warehouse containing up to 5TB of
ownership through efficient
deployments through simplified
access the data that they need,
implement your data mart or data
Reduced total cost of
Faster time to value with rapid
that users in your organization can
Services + Microsoft Software
started quickly. Customers also get
software, firmware, and BIOS
warehouse solutions helps ensure
The Dell hardware components were chosen to ensure the best performance at an affordable price.
capabilities in SQL Server. The hardware ships with the software preinstalled, to reduce both your
In partnership with
purchasing costs and installation
Their combined expertise results in
enhancements in data warehouse
times.
a ready-to-use optimized data
features, including:
The database management system software is integrated with the hardware purchase, eliminating the need to use existing corporate licenses or to purchase additional
warehouse solution out of the box. It is configured following the fast track reference architecture guidelines and designed specifically to deploy high
software.
performance data warehouse
Purchasing an integrated solution,
resources are needed to manage,
supported by a single vendor, can reduce the cost, time to implementation, as well as the risks
workloads, so less time and administer and performance-tune your solution.
associated with deploying a new
High Performance
data warehouse.
The Dell Quickstart Data
Fast Implementation and Simple Setup
Warehouse Appliance brings together the right combination of software, hardware, and services to
The time and cost implications of
provide you with a high
negotiating with and purchasing
performing and fast time to value
hardware and software from
solution data warehouse for an
different vendors can greatly
affordable price.
impact a new solution. The appliance ships in a ready-to-use state, with hardware and software that is designed to work together to meet the needs of medium sized businesses as well as business users in large enterprises. This reduces installation and testing time, so you can be up and running in a matter of days, rather than weeks or months.
Pre-optimized Solution The appliance is designed, installed, and configured by experts from Dell and Microsoft.
Data warehouses are often built on hardware configurations that are designed for transactional database systems and optimized for OLTP workloads. The Dell Quickstart Data Warehouse Appliance is based on the Fast Track Data Warehouse Reference Architecture, optimized to handle demanding data warehouse workloads. The appliance uses the latest SQL Server 2012 data warehouse appliance license, providing
The SQL Server 2012 database engine, specifically optimized for data warehouse query performance and high level of data compression. xVelocity in-memory technologies which is capable of improving query performance 10-100 times. Partitioned tables that scale up to 15,000 partitions. Capable of integrating with Microsoft and third-party Business Intelligence tools, including Microsoft Excel, for simplified analysis and reporting. Remote Blob Storage (RBS), which enables you to store binary large objects outside of the database in a dedicated storage location. Through these features, the appliance can provide a highly price-performance optimized system at a lower cost than building it in-house.
Easy Data Integration Dell simplifies data integration by including Dell Boomi in the Quickstart Data Warehouse Appliance. The Dell Boomi integration platform can connect any
In partnership with
combination of cloud and on-
to use Dell Boomi, familiarize you
Additional Information
premise data sources at a fraction
with the SQL Server 2012 features,
of the time and cost of
and put it all together using
conventional integration solutions,
hands-on training with your real
so the Dell Quickstart Data
use-case. Dell’s Global Support
Warehouse Appliance has access
team will handle all of your
For more information about the Dell Quickstart Data Warehouse Appliance with SQL Server 2012, go to Dell’s web site. http://www.dell.com/quickstartdw
to all the data sources it needs.
hardware and software technical
Benefits of using Dell Boomi
support needs. If you need
include:
assistance planning, designing, or
No additional hardware or software to install and maintain. An intuitive visual design interface that requires no coding. A suggestion engine for easy and fast data mapping. Centralized Web management of all integration processes.
Enhanced Services The Dell Quickstart Data Warehouse Appliance includes several built-in services: Dell Quickstart Data Warehouse Startup Foundation Pack Dell Quickstart Data Warehouse Quarterly Health Checks Dell is with you each step of the way to get your data warehouse up and running quickly. We start with complete installation services.
Join the conversation
implementing your data
www.microsoft.com/sqlserver
warehouse, business intelligence,
Or follow us! /sqlserver
or advanced analytics applications, additional data warehouse consulting services are available.
Simplified Support Resolving technical issues can delay the rollout, upgrade, or even simply the tuning of a data warehouse solution. Often, the resolution can require input from both hardware and software specialists, increasing the time and subsequent costs involved. Support for the appliance is simplified by using Dell as the single point of contact for all hardware and software components of the system, reducing the time and effort you need to dedicate to logging, tracking, and resolving any issues you may encounter.
After installation, Dell’s data warehouse Solution Architects will educate you on data warehouse concepts and leading practice reference patterns, teach you how
May 23, 2012
In partnership with