Overview

Introduction

The Configure Additional SQL Server Components module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

  1. Designing a Strategy to Maintain and Manage Databases

Exercise 1- Designing a Strategy to Maintain and Manage Databases

Rebuild for page-level compression

A new type of data compression was introduced in SQL Server 2008, available in Enterprise and Datacenter editions. Compression yields performance gains, as both storage and memory requirements are reduced due to the data being compressed both on disk on in the data cache. I/O is reduced by there being less data to actually have to read; however, this benefit comes at extra CPU overhead, but the net gain should be an overall performance boost.

For page-level compression, data is compresses by storing repeating values or common prefixes only once. When page-level compression is employed, row-level compression is switched on as well. The nature of the data stored in the object you are compressing will define how much the data is actually compressed. If there is a good deal of repeating data, compression will be highly effective.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.