Tags » Installation

Affinity and Parallelism

What Are CPU Affinity and IO Affinity?

CPU affinity is the process of telling SQL Server in a multiple CPU environment which CPUs are going to be involved/excluded in processing queries/managing data. 189 more words

Database Compression

What Is Data Compression?

Data compression is reducing the size that certain databases occupy by trading CPU cycles (abundance) in order to reduce I/O effort (constrained). 99 more words

Transparent Data Encryption

What Problems Does TDE Solve and How Does It Solve Them?

Encryption in general:

  • Protecting data in motion (e.g., SSL, TLS, IPSec)
  • Protecting data at rest (e.g., EFS, BitLocker, TDE)
  • 135 more words

Service Account Configuration

Account Selection During Installation

— Built-in Account

  • Local Service
  • Network Service
  • Local System

— Created Account

  • Machine Local
  • Domain

General rule: create a separate account for each service, for each instance… really! 82 more words

Plan for Growth and Capacity

Two DBA Cardinal Sins

  • Running out of space in a SQL Server data or log file
  • Allowing a data or log file to fill up a volume when autogrow is used…
  • 139 more words

Design the Storage for New Databases

Drive Layout: Design Windows File System for Expected I/O Patterns

Principle number one isĀ spreading.

Separate I/O activity on systems with heavy workloads:

Installation Decisions

Determine the Appropriate Hardware

To virtualize or not to virtualize?

In the past, it would have been far better not to virtualize, but with current technology, there is very little difference. 259 more words