Embrace Microsoft SQL Server With Confidence

Consolidating Mixed Workloads

Read Solution Brief

• Increase in database and server sprawl
• Larger workload footprints
• Greater cost and complexity running workloads on siloed IT
• Longer maintenance and upgrade cycles
• Inefficient copy data management

• Maximize valuable datacenter floor space with a smaller footprint
• Lower database licensing costs with fewer instances of the database software
• Manage CAPEX and OPEX at scale
• Deliver predictable performance at scale for mixed Microsoft SQL Server workloads
• Provision copies at the speed of the business through greater agility
• Improve backup and disaster recovery through centralization
• Ensure application-driven data protection and long term backup retention
• Enable cloud operating model efficiency and savings
• Strive for “Always On” in the digital era

Reference Architecture

• PowerEdge Modular Server
• PowerMax Storage
• Data Domain DD Boost for Enterprise Applications
• Data Domain Storage

Hyperconverged Infrastructure

• Storage Spaces Direct Ready Node

Converged Infrastructure

• VxBlock

Running SQL on Linux

Read Reference Architecture Guide

• Adoption of cloud operating model
• Move towards a data-driven intelligent enterprise
• Expansion into containerization and open source
• Standardize operating model for production and test / development environments

• Drive greater throughput on large complex Microsoft SQL Server queries
• Accelerate decision support analysis
• Scale under increasing Microsoft SQL Server workloads while providing strong storage performance
• Deliver consistently low latencies for accessing database data

Reference Architecture

• PowerEdge Servers
• XtremIO All-Flash Storage

Microsoft SQL Migrations and Upgrades

Read Solution Overview

• Microsoft SQL Server 2008/R end of support
• Invest in hybrid cloud operating model
• Incorporate meaningful insights into decision-making process
• Make Microsoft SQL Server data available in a timely, relevant and actionable manner

• Evaluate Microsoft SQL Server database environment to identify potential areas for performance improvement.
• Improve data quality with a modernized data landscape
• Design and implement resilient Microsoft SQL Server data architectures for on-premises, off-premises and hybrid cloud strategies
• Assess and plan for future business requirements

Dell Technologies Consulting Services

Reference Architecture

• PowerEdge Modular Server
• PowerMax Storage
• XtremIO X2 All-Flash Storage
• Unity XT All-Flash Storage
• Data Domain DD Boost for Enterprise Applications
• Data Domain Storage

Hyperconverged Infrastructure

• Storage Spaces Direct Ready Node
• Cloud for Microsoft Azure Stack

Converged Infrastructure

• VxBlock

Microsoft SQL Server 2019 Containers

Read White Paper

• Difficult to manage and ensure code and data consistency between RDBMS and applications
• Containers are reshaping how companies think about developing, deploying, and maintaining applications and software
• Concerns over lack of support for persistent storage of database files separate from ephemeral container files

• Quickly and easily deploy applications and databases consistently across multiple environments
• Deliver secure, isolated development and test environments in seconds
• Create persistent storage for stateful applications
• Simplify provisioning, management and orchestration of container storage
• Improve productivity and simplify application portability
• Spend more time building new applications and competitive business services

Reference Architecture

• PowerEdge Modular Server
• XtremIO X2 All-Flash Storage

Hyperconverged Infrastructure

• VxFlex Integrated Rack
• VxFlex Appliance

Microsoft SQL Server 2019 Big Data Clusters

Read White Paper

• IoT and connected devices are generating volumes of data that are exceeding the storage capacity of traditional database systems
• Inability to quickly and easily access all types of data, locked within storage silos, to perform business analysis and reporting
• IoT data sets are unstructured and without business context, often in formats that are not suitable for storing in relational database tables or for querying using relational query semantics
• Inefficient extract, transform, load (ETL) processes inhibits near real-time analysis.

• Enable intelligence over all your data
• Remove the limitations created from data silos by combining both structured and unstructured data across the entire data estate
• Deploy scalable clusters using Apache Spark, HDFS containers with Kubernetes, and SQL Server
• Deliver secure, isolated virtualized containers quickly and easily

Hyperconverged Infrastructure

• VxFlex Integrated Rack
• VxFlex Appliance
• Dell EMC VxRail