Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link:

Contents of this Issue


Page 189 of 212

177 C H A P T E R 9 | Introducing Azure SQL Data Warehouse Figure 9-1: SQL Data Warehouse architecture. SQL Data Warehouse includes many performance optimizations specifically designed for data- warehousing workloads. First, to support its MPP engine, it has a distributed query optimizer that parallelizes data-load and data-retrieval operations. To build an optimal query execution plan, the query optimizer relies on a complex set of statistics that cover the size and distribution of the data. Next, the DMS also uses algorithms and heuristics to move data efficiently among the compute nodes. Another optimization is the use of the clustered columnstore technology found in SQL Server that we describe in Chapter 1, "Faster queries." In a data-warehouse workload, columnstore indexes can compress data up to 5 times more than row-oriented storage and process queries up to 10 times faster. Analytic queries that are typical in data-warehouse workloads perform very well when you implement columnstore indexes. SQL Data Warehouse also includes data protection. Because SQL Data Warehouse data is kept in blob storage, all data is automatically written to Azure Read-Access Geo-Redundant Storage (RA-GRS). This storage type replicates your data to a second region hundreds of miles away from the primary region, crossing Azure fault and upgrade domains and ensuring that your data is durable even in the event of a complete regional failure or disaster. While infrastructure solutions are good, these do not protect against inadvertent user error that destroys data. SQL Data Warehouse has a built-in storage snapshot feature that takes a snapshot at least every eight hours and retains them for seven days for a discrete set of restore points. This service is built directly into SQL Data Warehouse and does not need to be configured. Note For a current list of supported data types and table features that SQL Data Warehouse does not implement, refer to "Migrate your schema to SQL Data Warehouse" at To get started with SQL Data Warehouse, click New in the Azure Management Portal, click Data + Storage, and then click SQL Data Warehouse to open the blade shown in Figure 9-2. You must

Articles in this issue

Links on this page

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016