Dell Quickstart Data Warehouse Appliance

0 downloads 317 Views 335KB Size Report
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