PreRequisites

Hardware

Component

Description

Setup as

Checked / Present

RAID

RAID

Fault-tolerance

RAID1(0) for DATA/TEMPDB/LOG/INDEX files

RAID1/5 for BACKUP files

☐

CACHE

BBWC

enabled

☐

Write cache

enabled

☐

Read /write cache ratio

60/40 (depends on your workload)

☐

DISKS

SAS

Operating System

10K - RAID1 minimum - 64K Preformatted 100%

☐

15K – RAID1 recommended - 64K Preformatted 100%

☐

Backup disk

10K - RAID1/5 to hold backup’s - 64K Preformatted 100%

☐

SSD

SQL Server Data Files

RAID1 – 64K Preformatted 100%

☐

MEMORY

SIZE

16GB minimum

☐

32 GB recommended or greater depending on requirements

☐

ILO/iDRAC

Support

☐

OS

Component

description

Setup as

Checked / Present

OS

Version

Windows

Windows Server Standard / Enterprise

☐

SP

Service Pack

Latest

☐

Volumes

OS

OS

C:\ 

☐

PageFile

Page File

X:\

☐

SQL Server

TempDB

N:\  (64K, Full Formatted)

☐

Logfiles (LDF)

T:\LOGS  (64K, Full Formatted)

☐

Database files (MDF)

I:\DATA   (64K, Full Formatted)

☐

Backup

Backup Files

Z:\ (any size on SAS enough to hold backup’s for business retention) or any network share

☐

Mounts

ISO

ISO Mounting tool

Any tool to mount ISO’s

☐

OS

Component

description

Setup as

Checked / Present

Security

Windows firewall

Off

☐

Antivirus

Off. If On exclude all SQL Server disks

☐

AD

Component

Description

Setup as

Checked / Present

Service account

SQL Server Agent Service

User account to run SQL Agent service

DOMAIN\sqlagent

Assign the local computer right: "Perform Volume Maintenance Tasks"

☐

SQL Server Service

User account to run SQL service

DOMAIN\sqlservice

Assign the local computer right: "Perform Volume Maintenance Tasks"

☐

Domain Groups

SQL Server DBA’s

AD Global group to host DBA Administrators

DOMAIN\GROUP

Service accounts should be member of this group

☐

SQL Server Users

AD Global group to host DBA users

DOMAIN\GROUP

☐

DNS

DNS Aliasses

Create DNS aliasses to connect to SQL Server

☐

MULTIPLE  INSTANCES

(HIGH AVAILABLE)

Component

Description

Setup as

Checked / Present

SQL Server

Version

Version

SQL Server Enterprise Edition

☐

Instance name

SQL Server instance

DEFAULT

☐

Binaries

ISO mount

☐

Listening ports

Listening ports

60000 recommended

☐

Always ON

Availability Groups

VIP and VDNS

Add extra IP and DNS to decorate AG group listener

☐

Windows Clustering Services

Windows Clustering

Installed

☐